Corrupted File in Dynamic Input
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
that worked! thank you for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
