Wildcard XLSX input tool giving the header names in ROW 1
- 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
I'm using wildcard xlsx input tool to read multiple tabs from an excel file. The issue that I'm facing is that the output from macro has incorrect header names....F1,F2,F3 and so on. The header values are displayed in row 1. When I uncheck the option of row containing headers then it does not help. Any idea on how I can solve for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Idyllic_Data_Geek ,
The First Row Contains Data shold work. Please note that you need to save the macro (if you are talking about the wildcard xlsx macro), so the changes will be reflected on your main workflow.
uncheck
check
Could you provide the workflow with some dummy data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is what I have
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I downloaded the tool and tested it here, for me the header is working fine. Take a look at the attached workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
