This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow which formats data and writes it to an existing excel template. The excel file it writes to contains multiple sheets including a main sheet which contains a formula that references the sheet Alteryx is writing the data into. On Designer, I have the output tool setup (pictured) to "Overwrite Sheet (Drop)" with the sheet name referenced in the file path.
The workflow works fine when running it from Designer: it will overwrite the sheet reference in the Output tool each time while keeping the other sheets intact. My issue is when I publish the workflow on the Gallery and run it from there it will overwrite the entire excel file. Has anyone experienced this? It appears to be a bug with the Gallery because it works each time it is run on Designer.
Also note that the workflow includes an Interface tool which allows users to select a data file from their local device.
Hi @AndrewRoda, I generally use the approach of writing to specific sheets in existing .xlsx files and it works fine from the Gallery. Just make sure you are specifying the excel file tab name in the output path when writing to the file, i.e. c:\somefoldername\dummy.xlsx|||sheetname.
That is the approach I am currently using. I am specifying the tab in the output path and it works as intended when I run the workflow from Designer or run it as an Analytic App from Designer. Once I save the workflow to the Gallery and run it there, it is overwriting the excel file and deleting the other tabs.