OutPut .xlsx format tab name garbage

[asq]

Alteryx Version: 9.5 (I know I'm behind, but can't update until our server is updated)

Workflow is pulling data from odbc connection

Output format is .xlsx

Only need to output data on one tab

Problem:

Workflow generates file but I'm presented with a message that reads:

"Excel found unreadable contents in 'test.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

When I click Yes, I'm presented a Repairs to 'test.xlsx' dialog box

"Excel was able to open the file by repairing or removing the unreadable contents."

Clicking close, I'm presented with the excel file but the tab name is garbage

Any ideas on how to resolve this?

[MarqueeCrew]

Thoughts:

1.  Is there a "LEGACY EXCEL DRIVER" that you can use?

2.  If you are outputting to a single worksheet, would you object to writing to a .CSV?

Quick thoughts only, because I'm at inspire right now.  You might want to walk through the issue with support@alteryx.com

Thanks,

Mark

[asq · Accepted solution]

They way that I ended up overcoming this issue was by doing the following

In the Output Data tool was by adding a pipe and what I wanted to name the tab in the output file. I also set the Output Option to Overwrite Table (Drop)

Then in the action tool, I set the replace value to replace the file name