error importing excel files from directory node
I keep getting the below error on multiple excel imports - can you advise what this error is indicating?
Sheet definition specifies an auto-indexed sheet. This resolves to index 1. However, this sheet does not exist in the input file T:\Group Fraud & RA\Lavastorm\2020 Projects\20.060 WIN Roaming\Accounting purposes reports_012020_112020\Payment Allocation_EUR unzip\Payment_allocation_2020_01_10_EUR.XLS. Error occurred at line 3, column 26 in WorkbookSpec.
-
Does the layout of the workbook differ from the other files that you are trying to import?
What happens if you change the workbook spec to the following:
<workbook>
<sheet headerRow="2" />
</workbook>Can the file be imported on it's own (i.e. specifying the filename in the node's 'File' property?
Can you create a copy of the file with just the first three rows (with the data row containing dummy data), confirm it still gives the same error and attach it to this post?
Please sign in to leave a comment.
Comments
3 comments