Delete Data and Append for Standard Excel .xlsx Files

[drahn]

For the Output tool, File Format of Microsoft Excel (*.xlsx) - the non-Legacy one - it doesn't have the "Delete Data & Append" option that the Legacy ad 97-2003 Excel formats have. 

Having the Delete Data & Append for the most recent version of Excel would be very beneficial. Without it, there does not appear to be a way to udpate an existing Excel sheet using an Alteryx workflow while preserving the formatting within the Excel sheet. The option to Overwrite/Drop removes all formatting. 

I have this workflow refreshing an Excel sheet daily, and then am emailing it to a distribution at the end of the workflow. Unfortunately, right now I have to use the 97-2003 format to preserve the formatting of the Excel sheet when it is automatically refreshed and emailed each day. 

Can you please assess adding this option? Thanks!

[ARich]

Hi All,

Thanks for the feedback- please continue to star if you have a need for this feature.

Best,

Alex

[Ricky]

I am encountering the same issue.  My daily work requires Alteryx to output to multiple designated named ranges to multiple excel spreadsheets (*.xlsx).

The legacy excel output ("Delete Data & Append") feature works just fine until a recent Alteryx update which seems to have this function removed.  The overwrite /drop feature can output data however the format has disappeared. 

Currently I have to manually restore the format one file by one (>20 files), as my deliverable is for public release so there is no chance to compromise presentation. 

Is this my own problem, or the legacy excel output is no longer supported?  

[PiotrGa]

Hi,

We have quite complex reports prepared for FIN REPORTING in our financial institution, using the option "Delete Data & Append", was the solution working in our cases. We had prepared the templates and populate them with preserved formatting. Now it is not possible with xlsx. I hope it will return in the next version.

---

---

[j_acon]

Need more stars

[Newt]

Being able to preserve Excel formatting when outputting to the .xlsx format is crucial for many organizations that use Excel to directly present data.

[pennymiller]

This would be nice for .XLSM files also