Append to exiting sheet Range on Server

[hemant86]

Hi Team,

I have a requirement to append my output to an existing file to a particular range. I am able to achieve this on Desktop App but not able to make this possible on server. Is there a way around this. Appreciate any help.

[trsali]

@hemant86 Is your output located in your local drive?

What error are you receiving when you try to run on server?

[hemant86]

Hi @trsali Thanks for your response. Its not giving any error, just producing a new file. without the formatting in existing file.

[trsali]

@hemant86 what does your output configuration look like? Is it appending to existing sheet and locating the appropriate sheet in the configuration?

Is your file saved in a shared network/ network drive that your server has access to?

[apathetichell]

Your issue is your file location. On your desktop your file is in a static location - so when you append you know where that goes. On Server you need to clarify exactly where the  file you are appending to will be located. You should do this by some combination of:

[engine workflow directory]+"myfilename.xlsx|mysheetname$myrange"

Note - one "|" - not "|||"