Write to an existing file through Analytics App

Question

Is there a way we can write to an existing excel file through alteryx app? So lets say there are two sheets in an excel file. One has data which gets updated when the app runs. The other sheet has some graphs which should remain as is.

This is possible in designer. However, with app every time the output file gets replaced and the sheet-2 also gets removed.

SeanAdams · Answer

When writing to files from the server - it's important to think about file location.

Rather than writing to the local server (C:\users\Nisha...) - you would want to write to a network share or UNC location (\sharename\folder) - the reason being that if you write to the server you will eventually end up filling up the server with stuff that needs to be cleaned up and the server will grind to a halt.

by writing to a UNC path - the same code will be running on desktop as on server - and you should be able to test the functionality on your desktop before running on the server.

DataNath · Answer

@NurulAli what's your app doing? Are you able to share it here with some example data or at least some screenshots and such showing configurations?

NurulAli · Answer

Thanks @DataNath. Tried this as well. This works in Designer but not in App once published.