Create new worksheet with PowerTools for Open XML (in PowerShell)

Sep 3, 2013 at 11:04 AM
I'm trying to create 2 or more worksheets in excel spreadsheet
Is that possible? I'm googling now for hours, and can't find anything...
Even tried to merge 2 excel file into one with separate tabs/worksheets - no...

Export to excel file is easy as

$variable | Export-OpenXmlSpreadsheet ps.xlsx

but I'd like to export $variable1 to workseet ONE, $variable2 to worksheet2 etc - all in PowerShell

Is that possible?
Oct 4, 2013 at 9:12 AM
Hi,

Currently, there is no way to do this using the PowerTools for Open XML. I've added this to my list of future projects.

Cheers, Eric