Getting Output in an existing Excel File

Question

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.

Nanoq · Answer

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

atcodedog05 · Answer

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 : )