Relative Content

Tag Archive for powershellhashtableimportexcel

Powershell : how to pass a hashtable as args for parameter -PivotData with Export-Excel command (ImportExcel Module v7.8.6)?

I could manage to build a simple script that collects some system metrics from different computer as a scheduled task, and export them into CSV files (one per computer). I am now trying to complete that first script with a second-stage script that works on all CSV files, turning each one into an XLSX file with two sheets : “DATA” and “CHARTS”, using the Export-Excel command. Then come troubles…