3 ms·
> "Sometimes the feedback involves making a minor tweak on every Worksheet." Could be a good task for PowerShell and the ImportExcel module[1]. (PowerShell al
by jodrellblank 4y ago
> "Sometimes the feedback involves making a minor tweak on every Worksheet."
Could be a good task for PowerShell and the ImportExcel module[1].
(PowerShell also being a .NET language and written in C#; it has convenient access to COM control of Excel if you can't import the spreadsheet and export an updated version; through $xl = New-Object -ComObject Excel.Application )
[1] https://github.com/dfinke/ImportExcel https://github.com/dfinke/ImportExcel