How to Open, Save, Close an Excel file

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

Image 1.jpg

Image 2.jpg

Input

Run Command

Accepted answers

All comments

wwatson

Is the file you download from the website saved in CSV format or xlsx?

raghusrealm

@wwatson

it is in Xlsx format

wwatson

There is something wrong with the sheetname in the xlsx file it downloads:

taxguy33

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.

bertal34

@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.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/how-to-resolve-this-issue-The-Excel-archive-is-corrupted-shared/m-p/1124376

taxguy33

@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.

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335