ImportExcel icon indicating copy to clipboard operation
ImportExcel copied to clipboard

Add -Calculate to Open-ExcelPackage and Import-Excel

Open tolgabalci opened this issue 2 years ago • 0 comments

I am using this package mainly to read and process existing spreadsheets. I read spreadsheets and use the results from cells with formulas in them.

Today this does not work with just Import-Excel or Open-ExcelPackage. You must Open-ExcelPackage, Close-ExcelPackage with the -Calculate parameter and than once again Open-ExcelPackage.

Can we add -Calculate parameter to both Import-Excel and Open-ExcelPackage to avoid the additional steps?

tolgabalci avatar Feb 15 '24 04:02 tolgabalci