Working with Excel

Welcome Forums General PowerShell Q&A Working with Excel

This topic contains 1 reply, has 2 voices, and was last updated by

 
Participant
2 months, 2 weeks ago.

  • 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: 24
    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

You must be logged in to reply to this topic.