Multiple Tabs in Excel

[vijaylnyadav]

I have a multiple output data(more than 10) and I want to save all the data in a single excel file.

I am using folder browse so that the user can select their desire output after that I am using action tool that will update the output with formula but i am facing an error and i.e. sometimes it is saying that access denied and sometimes it is saying that file is being used by different process.

Therefore I have used block until done but still I am facing the same error and I am unable to save my output to multiple tabs in single excel files.

Some solutions will be a great help.

i have attached a sample data and sample workflow for your reference.

I am stuck at this point so please help me out.

[AkimasaKajitani]

How large is the actual data?

Our mini size data is no problem.

You say the destination is a local disk, but the folder is not synced with DropBox or other online storage, is it?

[vijaylnyadav]

My actual data is very large,

The output is produced in excel format in say more than 1000 in one tab...

But in future I want to take the input from network devices and save the output excel file with multiple tabs on a network storage.

So what should I do to achieve without any error.

[AkimasaKajitani]

I haven't heard of many problems with input, so I think it's a no problem.

But I often have problems when outputting to an Excel file to a network drive or a folder that syncs with online storage.

There is a way to save the output to a "complete" local folder and then use the Command Line tool to create a batch file and copy it.

Please refer this post.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Batch-Files-in-Alteryx-Part-2-Movin...

Although it is "Move Files" that is being mentioned in this post. You can do the same way with Copy.

[thpmaganti]

Did you find any solution for this.. I'm facing the same issue. when i'm trying to split 180 rows of data into 15 sheets of same excel using a fieldname to split.