Designer: Output to Excel - Overwrite Range breaks Excel File

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?

1.png

2.png

3.png

Bug

Accepted answers

All comments

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

4.png

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703