locked
Import-Excel - Export Columns RRS feed

  • Question

  • Hello, 

    I am using Import-Excel to import a spreadsheet into PowerShell. I want to export specific columns to a separate sheet in the same spreadsheet. I know this is likely a simple task, but I'm having trouble finding examples. Any information is appreciated! 

    - Matt

    Wednesday, February 20, 2019 6:03 PM

All replies

  • Did you search for it? Did you read the help for the cmdlets?

    There are videos available and there's a Comments section in the Powershell Gallery. I'd think you could try Add-Worksheet to create a new worksheet. The help for the module might not be the best in the world but you should at least read it. If you have code you're stuck with you should post it here (formatted as code please).


    Live long and prosper!

    (79,108,97,102|%{[char]$_})-join''

    Wednesday, February 20, 2019 6:28 PM
  • help select-object -online
    help export-csv -online


    \_(ツ)_/

    Wednesday, February 20, 2019 6:57 PM
  • Hi,

    Was your issue resolved?

    If you resolved it using our solution, please "mark it as answer" to help other community members find the helpful reply quickly.

    If you resolve it using your own solution, please share your experience and solution here. It will be very beneficial for other community members who have similar questions.

    If no, please reply and tell us the current situation in order to provide further help.

    Best Regards,

    Lee


    Just do it.

    Monday, February 25, 2019 7:13 AM