Corrupted File in Dynamic Input

[czjames87]

Good morning,

I am having issues pulling in an .xlsx file into my workflow. Every time I run my flow it errors showing that the file is corrupt or no sheet is specified. I have put in the sheet name using the formula tool in my flow. I have attached both the flow and the excel sheet I am trying to use. I am not sure if its the file path or the folder I am using but any help would be greatly appreciated. 

[mceleavey · Accepted solution]

Hi @czjames87 ,

It appears you have a corrupted sheet name, which is *sarcastic* shocking for Excel...

I've attached a workflow and a couple of tools which will help you do what you're trying to do avoiding the potential pitfalls of multi-schema Excel files.

Save the tools in your macro folder then open your Excel file and simply overwrite the sheet name with the same Sheet1 name. Save that, and run it.

Hope this helps.

M.

[czjames87]

that worked! thank you for your help. 

[mceleavey]