I am trying to connect an Excel file (this file is downloaded from a website using another workflow) to input tool but it is not reading the sheet name. Refer to image 1.
But, when I Open, Save and Close the Excel file and connect to input tool, I am able to get the sheet name. Refer to image 2. This is after the excel file was just opened, save (CTRL+S) and Closed.
I need help to figure a way to Open, Save and Close the excel file using a workflow may be using a Run command or something.
Any help in the form of a workflow would be highly appreciated.
Regards,
Raghu
Is the file you download from the website saved in CSV format or xlsx?
I've not seen a case where Alteryx couldn't open an xlsx file and prompt you for the sheet name.
IYou say you created the xlsx file with a workflow. Could you show the configuration of the output tool from the workflow that creates the xlsx file?
I ran the workflow to download the file to the desktop. When I use an input tool in a fresh workflow I get prompted to choose the sheet. So it looks ok to me.
There is something wrong with the sheetname in the xlsx file it downloads:
Did anyone figure out how to fix this issue? Still encountering this issue as it seems many others are on many other threads.
I have many Excel files (.xlsx) that have a Sheet1 but I can't get an Input Tool to recognize the sheet name as valid without opening up the Excel and saving them.
@taxguy33 - see link below. I am having a similar issue and according to leofrancia at Alteryx, it is because the excel file has a prefix x: in all the tags in the Shared String XML embedded in Excel. Might be the same issue you are having.
@bertal34 This is the exact issue I am facing - even to the point where I'm talking about spreadsheets created by an RPA tool (UiPath) that causes this corruption. If you are able to figure out a way to avoid this, please share. I'm at a loss for how to proceed based on the example / links Alteryx personnel provided to you.