0

We are planning to generate XLSX format to generate a report using powershell. we are able to CSV format , but we are unable to add colors in csv file.

Can any please help how to generate XLSX using powershell?

closed as off-topic by Robert Lindgren Mar 16 '17 at 11:23

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Programming questions not specific to SharePoint are off-topic here, but can be asked on Stack Overflow." – Robert Lindgren
If this question can be reworded to fit the rules in the help center, please edit the question.

1

There's a script created by Peter Kriegel on the TechNet Gallery that does this. You could simply leverage Peter's script or tweak it to suit your needs. The script is listed here:

https://gallery.technet.microsoft.com/office/Export-XLSX-PowerShell-f2f0c035

Not the answer you're looking for? Browse other questions tagged or ask your own question.