Adding Reports as Excel worksheet tabs

Unknown

Adding Reports as Excel worksheet tabs

Unknown

I know how to export a report to an excel file, but I would like to show multiple reports in one excel file with worksheet tabs. Can I map a report to an excel worksheet?

Unknown

Assuming youre accomplishing this with a Flow containing the Run Report step, you can add the [b]Add Worksheet[/b] step found in [b]Data > Excel & CSV [/b]to logically add a worksheet into the specified Excel file.

To map the report youd like to show in a tab, take the output of the Run Report (or whatever step would be outputting your Report as FileData) and map it to the Input input in the Add Worksheet step.

You can use a loop of the a list of report FileData and the Add Worksheet step to do this for every tab youd like assuming that each worksheets name and/or file type can be entered dynamically. Otherwise, you will have to enter and map this data manually for each tab.
[i]edited by amber.blanton@decisions.com on 1/7/2022[/i]