We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Exporting Excel taps to individual worksheets

jfrink1
5 - Atom

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.

4 REPLIES 4
OTrieger
13 - Pulsar

@jfrink1 
Get your original workflow to create also the individual file for each custodian.

TUSHAR050392
11 - Bolide

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.

jfrink1
5 - Atom

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
11 - Bolide

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.

Labels
Top Solution Authors