Writing data on multiple tabs in excel spreadsheet

[Vikas038]

Hi Team,

In my WF, with output tool, I am writing my output in mutiple tabs of a spreadsheet. Also, in some cases, writing chunks of data in different cells of  a single tab. For instance, in tab "Segment", writing data on A1:G1, A10:G10 and M1:Q2 but it gives me error "Attempt to open a file that is already open". Although, I am closing the spreadsheet before running the WF. 

Please suggest solution on this.

[messi007]

@Vikas038,

You have to use a block until done before each output.

Hope this helps!

Regards

[Vikas038]

Hi Messi,

Missed to add that I am already using "Block until done" in my WF with each output tool but still it is showing up that issue.

[ArtApa]

Hi @Vikas038 - Would you be able to provide a sample WF with a Sample file to replicate the problem?

[DawnDuong]

hi @Vikas038 

You can check out this Knowledge Base article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separ...

[Vikas038]

Hi Dawn,

Thank you for sharing article for better understanding. Although, I am using like 10 summarization outputs to write in same file in different tabs. So, for 9 summarization, I am putting 3 block untill done(one against 3 summarization). Would that be a correct approach?