Getting Output in an existing Excel File

[hemant86]

Hi All,

Is it possible to get an output in existing excel file/worksheet. I have a excel file with a particular templet with formulas in it. I need to update the data only to certain cells. Is that possible. When I try to select an existing file in Output tool its asking to rename or replace the file that means its creating a new file.

Appreciate an advice.

[atcodedog05]

Hi @hemant86 

You can try out preserve output formatting. This way it overwrites to an existing excel template. $C6:AM2000 is the range that you want to write to.

Hope this helps : )

[Nanoq]

You can specify that you want to create a new table in the same file.
You might get some issues with opening and writing to a file at the same time, if thats the case, you can use the "block until done" tool to ensure that it will only save data once its done reading it