putexcel: using putexcel set to create a worksheet, then "sheet" to create multiple worksheets. How?

[matthewteel3]

I'm running several regression and want to export them to excel format. I've got something like this to create the workbook and first worksheet: putexcel set "fakepath\fakepath\workbook.xlsx", sheet("firstsheet") How do I from here just use the same "workbook" and make new sheets to it?

[Joe Canner]

Matthew,

I haven't used putexcel, but from the documentation it looks like you can add the modify option to your putexcel set command and then subsequent putexcel statements can be used to add new sheets the original file.

putexcel set "fakepath\fakepath\workbook.xlsx", modify
putexcel expression "fakepath\fakepath\workbook.xlsx", sheet("firstsheet")
putexcel expression "fakepath\fakepath\workbook.xlsx", sheet("secondsheet")
...

Regards,
Joe