Unexpected output in xls file format

Question

Hi Everyone,

I am trying to create a workflow to extract data and overwrite a xls file to keep the data up-to-date with formula contains. I downloaded the Access Driver and there is no issue on writing data, but the output format look weird and i hope someone can advise.

I am targeting to over sheet "Data2"

Formula tab:

Data1:

Data 2:

I would like to replace 100 in Data 2, and my expected result is "2" will change to "100"

and this is my output configuration, i select output options = overwrite sheet as same as xlsx format.

After running the workflow, i do see "2" is gone but "100" is placed in cell A3, and my formula cannot read it because it fixed to read cell A2

When i continue to run the workflow, the data will continue to move downward

Did i setup something wrong? Or is there any workaround i can make sure the data will place in the right place?

Thanks a lot!

formula.xls

SoccerTil · Answer

This sounds like a bug. If you write a new sheet the data is fine. You could go to an extreme length to create a new sheet, drop the old sheet, and rename the new sheet. That would involve some fancy macros or python code. So I'd start with opening a bug.

Will_Cheng · Answer

I know convert to xlsx is the easiest way, i also know we have some many people interact with that xls file, i dont want to change the format that could cause lots of error. In this case, overwrite the tab but not changing anything else is my intend.

SoccerTil · Answer

sorry to say, I can easily repeart your problem. I tried a few workarounds that resulted in other errors or abnormal behavior. Might be a bug or a problem with reading and writing from the same spreadsheet in the same workflow. I converted the speadsheet to an XLSX but had to add a Block Until Done to avoid currency issues. The workflow ran successfully. Can you convert the file?