We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

error importing excel files from directory node

Follow
Avatar
Laura Lacey

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.

0

Comments

3 comments

Sort by Date Votes
  • Avatar
    Adrian Williams

    What is the WorkbookSpec property set to in the Excel File node? 

    Has the first sheet been deleted in the Excel file that is referred to in the error message?

    0
    Comment actions Permalink
  • Avatar
    Laura Lacey

    <workbook>
    <sheet/>
    <sheet headerRow="2" />
    </workbook> 

     

    and no sheets have been deleted 

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams
    • Edited

    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?

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post