Working with Excel

PowerShell Help
1

Hi Friends,

Need some help with below scenario.

  • I have several CSV files, each with around 500MB.
  • I need to copy specific columns to specific columns of another sheet ( in another workbook)
Excel is getting crashed if I do it using GUI so looking for some alternative using PowerShell.

Cheers,

Narayan

2

Hi,

If you can load your CSV in memory, did you tried using the importExcel module (https://github.com/dfinke/ImportExcel) to export your result to Excel directly?

Now if your issue is to be able to parse big logs, I personally use LTFViewer for this.

Cheers

François