Hi Alteryx Community,
I am reaching out for assistance with a problem my team and I are encountering within a multi-chained Alteryx application that interfaces with Microsoft Excel. Our application consists of three main parts:
In the final app, we output multiple files to Excel. While most of the files are posted without any issues, we are consistently running into a problem with one particular excel file (.xlsx). When we attempt to open this file in Excel, we receive the following error message:
If we proceed by clicking 'Yes' to recover the contents of the workbook, we find that the file formatting is severely disrupted, rendering the file unusable.
We have tried to troubleshoot this issue internally but have not yet identified the root cause or a solution. Here are some specifics about the problematic file and our process:
We would greatly appreciate any insights or suggestions from the community on how to resolve this issue. Has anyone encountered a similar problem, or does anyone have recommendations on steps we can take to diagnose and fix the error?
Thanks,
Isabelle
does this excel file have a space or special character either in the sheet name or file name which does not occur in other files?
Hi, thanks for the response. There is a space in the sheet name of the file, but not the file name itself.
your sheet name has to be wrapped in quotes - ie `sheet name` for sheet names with spaces you can test formatting via dragging an input data tool onto canvas select a file/sheetname combo with a sheet name with a space. drag an action tool to edit it. look at the formatting.
Thanks for the recommendation, I will investigate this further. Appreciate the insight.