General Discussions

Discuss any topics that are not product-specific here.

Rendering multiple tables onto separate tabs of the same Excel spreadsheet

avalachovic
5 - Atom

I am trying to render multiple tables onto the same spreadsheet but want to keep them on separate tabs. I know how to create multiple tabs using the "Output Data" tool but I would like to keep the table formatting. Is there a way to do this?

1 REPLY 1
griffinwelsh
12 - Quasar

@avalachovic  one approach is to output the formatted reports to separate files and then use a python script to merge the workbooks. See the below thread if you are interested in this approach.

 

https://stackoverflow.com/questions/74646115/merge-all-excel-files-into-one-file-with-multiple-sheet...

Labels