Render tool output created corrupted excel file with multiple tabs

[Link86]

Hello, I am trying to make my excel tabs look better by using the table, layout, and reporting tool as shown in this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reporting-Tool-Multiple-tabs-in-one-ex....

However, what I am getting is corrupted data as the output with an error in excel saying something about opening an xml file. I am saving as xlsx. Is there a way to prevent this?

Thank you in advance.

[AkimasaKajitani]

Hi @Link86 

Do you use the Render tool to save the data?

If you use it, please tell me the Designer version and please share the workflow or screen shot if you can.

If not, you should to use Render tool.

[Link86]

Yes, its 2021.2. It works with small data, but larger files it does not. This image is a mock up, the first three inputs are small and fake, and they work. The last one is a real file, it breaks on this. The real data other than this basic excel file comes from db's and also break. But if i output with the output tool, no problem. we are trying to make them look nicer in the table output with render.

[AkimasaKajitani]

Hi @Link86 ,

Does your data contain negative value that is truncated because of too short column size?

In this case, I found that the Excel file was to be broken.

If that column is not truncated, the Excel file will not be broken.

[Link86 · Accepted solution]

The solution was the render tool was not configured to have long column names. Adjusting the page size in the render tool resolved the issue.