Working with Excel

Welcome Forums General PowerShell Q&A Working with Excel

Viewing 1 reply thread
  • Author
    Posts
    • #164298
      Participant
      Topics: 5
      Replies: 4
      Points: 32
      Rank: Member

      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

    • #164331
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      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

Viewing 1 reply thread
  • The topic ‘Working with Excel’ is closed to new replies.