Read and Write Excel Spreadsheets With ImportExcel PowerShell Module
Whether it’s just storing rows of data or it’s serving as a full-on presentation tool with pie charts, graphs, and macros, we can’t escape Excel. Excel workbooks have been around for a long time, and they store lots of data. And where the data is, we usually need to be. When it comes to automation, Excel does not behave well. It’s traditionally known for its complicated COM objects and slow performance in PowerShell. Thus, I would usually recommend converting the data into a CSV file before reading. However, there are times to keep that Excel workbook intact and keep the data source untouched before reading the information. Luckily, the introduction of PowerShell 5.0 made reading a lot faster. And with a community module called ImportExcel, reading Excel worksheets has become a whole lot easier.
Read the full article at 4sysops.