format excel file after export-csv powershell

Question

Brand new to powershell and trying to modify an existing script.

There is a line that exports a csv file.

Get-Devices $accountID | Export-Csv -Path $DevicesCSV -NoTypeInformation -NoClobber

and It does what it is supposed to do and I get a file in the path specified...

What I want to do is make the file look pretty, make it into a table in excel so columns can be sorted. Add formatting, etc.
I do not see any options to do that and need some guidance on how to accomplish this.

Robert Dyjas · Accepted Answer · 2019-05-23 13:55:44Z

2

There are some workarounds, but the easiest way would be to use dedicated module for this, such as ImportExcel by dfinke. It allows you to work with Excel files both ways (importing/exporting).

Get-Help is your friend if you want to learn more about what specific cmdlets like Export-Excel could do.

If you want to sort the data, you can do this before exporting, using Sort-Object cmdlet.

answered May 23, 2019 at 13:55

Robert Dyjas

5,2373 gold badges22 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

format excel file after export-csv powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related