Dynamic input not reading header from .xlsm file
- 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 have an input .xlsm file that needs to be read using the dynamic input tool. The 1st row in the sheet is the header and the remaining contains the data. In the preview for the dynamic input tool the headers are accurately visible, but when running the workflow the first row of data is being taken as the header. What can I do to resolve this issue? I'm able to correctly input other sheets of this same file in other parts of the workflow.
- Labels:
- Dynamic Processing
- Help
- Input
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AnnSuzane
Could you please share the dynamic input configuration that you are using? The First Row Contains Data must be unchecked and the Start Data Import on Line must be properly configured to the first row (if the header is on the first row of the xlsm sheet, use 1)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had made these specifications in the configuration but still was getting the same error. I ended up converting the file from .xlsm to .xlsx and the error resolved itself. Thanks for your input.