ImportExcel
ImportExcel copied to clipboard
Add -Calculate to Open-ExcelPackage and Import-Excel
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?