Append to xlsx works fine, but overwrite does not?

[ylamlih]

Hello,

I've built a simple workflow that manipulates data and then need it to overwrite a sheet in an Excel file except for the column names.

My setup is thus as follows:

For some reason, if I run this workflow it will just keep on running until I cancel it myself without any errors, see below:

I've tried running the exact same workflow with the same destination file, but using the 'Append' setting instead of 'Overwrite' and that works fine and finished in 4 seconds.

Anyone got any idea what I'm missing here? I'm running the latest version of Alteryx 2020.2.3.27789 in non-admin.

Thanks!

[DavidP · Accepted solution]

Try adding a cell range to the sheetname that starts writing at row 2.

For instance, if you have 10 columns and want to write from cell A2 to the end of your data, you can specify filename.xlsx|||Sheet1$A2:J

J represents column 10. By omitting a number, it will write all the rows in the data set.

[ylamlih]

Works a charm! Thanks for the quick help 🙂