Exporting Excel taps to individual worksheets

Question

I currently have a workflow that creates an Excel worksheet that has multiple tabs in it.  The worksheet and tabs are for asset custodians.  So the asset custodian could change from year and the number of tabs could change as well.  I am looking for a way to export each individual tab to a separate Excel worksheet.  This will allow me to email them to the custodians for review.  I saw a couple of workflow questions about this one was a work sheet with Austria and other countries but think that was not what I want to do.

TUSHAR050392 · Answer

Hey @jfrink1 I think you can change the file type from CSV to Excel when you are exporting the data. That shouldn't be a big issue. Let me know if you are able to do that.

jfrink1 · Answer

This video is for creating a CSV file.  I want to export my data to multiple excel files.  Do not want user to have to convert CSV file to Excel to many worksheets will be created

TUSHAR050392 · Answer

Hey @jfrink1 I think you can use a custodian field to create multiple excels. Check out this video - https://www.youtube.com/watch?v=XXwMJHqK1PM

Hope this helps.