Designer: Output to Excel - Overwrite Range breaks Excel File

[aschlich]

Hello,

I'm trying to output data to an existing Excel sheet. The output works without issue if it creates a new sheet. However, anytime the output is directed to a specific range in an existing sheet it damages the excel file and must be repaired. After the repair, the output Excel doc has all the rows cleared for the selected range below the header. Does anyone have any workarounds?

[christine_assaad]

Hi @aschlich 

Can you update the range to include rows like in the below screenshot?

[aschlich]

Same result as before, except it now cleared all the columns out to Z as well as the rows down to 1000

[christine_assaad]

Hi @aschlich 

It does not have to be Z. In your case it could be for example A1:En with n being the number of rows you are expecting to write.

If you can provide data samples, i could help you better. Thanks!

[apathetichell]

You need to include the exact area you are writing to and it has to match the number of columns you are writing. so in your case - you need to have A1:E5000 (with column headers) or A2:E5000 (without column headers). You need to feed exactly 5 columns into your output data. Your sheet names need to match - exactly.

[aschlich]

The columns were specified in the initial run before trying the posted alternative solution. Does not fix the issue

[apathetichell]

Your original screen grab says A:E - it has to include the rows as well. It can be A1:E5000 etc... also - can you confirm that the sheet name you are trying to write to matches the sheet name you are writing to? And can you post a screen grab of the output log with the output data tool writing?

[apathetichell]

it would also help if you can detail how many columns and rows you are trying to write - also you can't write over formulas.