Write to an existing file through Analytics App

[NurulAli]

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. 

[DataNath]

Hey @NurulAli, in the configuration of your Output Data tool, initially set it up with the sheet you want to replace, then select 'Overwrite Sheet or Range' from this menu. It'll only replace the selected sheet rather than Overwriting/replacing the whole file:

[NurulAli]

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

[DataNath]

@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?

[SeanAdams]

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.