Corrupted File in Dynamic Input

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.

DOM+Claims+Workflow+-+Working.yxzp

2021-04-13 Report.xlsx

Developer

Developer Tools

Error Message

Tips and Tricks

Accepted answers

mceleavey

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.

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

DOM Claims Workflow - Working.yxmd

All comments

mceleavey

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.

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

DOM Claims Workflow - Working.yxmd

czjames87

that worked! thank you for your help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703