Multiple Tabs in Excel

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.

multipletab.yxwz

Datasets

Accepted answers

All comments

AkimasaKajitani

Hi @vijaylnyadav

On my environment your workflow work well.

Do you set the location of saving the Excel file at the Network drive and so on?

jrgo

Hi @vijaylnyadav

The workflow you shared ran fine for me, but I tested by writing to a local path on my machine. Targeting a network folder or cloud (i.e., OneDrive, Box, etc.) it may already be trying to sync the file after the first one drops.

Attached is an alternate approach that you can test. The output this produces is identical to what your original workflow produced, but not sure how applicable this design will be when you plug it into your actual data.

Main difference is that it only uses one Output tool, but the output path is entirely replaced with a file path that is created beforehand.

Happy to explain further if needed.

Hope this helps!

Best,

Jimmy
Teknion Data Solutions

multipletab_jrgo_edit.yxwz

vijaylnyadav

I am saving my excel output to local device and also taking input from local device.

On my pc this workflow is not working please suggest some alternative solution to save a single file with multiple tabs using the same workflow schema

hroderick

There is syncing or backup happening after you close first tab. Try writing to c:\temp.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703