Writing data on multiple tabs in excel spreadsheet

Question

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.

Vikas038 · Answer

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?

DawnDuong · Answer

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-separately-without-errors/ta-p/33413

ArtApa · Answer

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