Data360 Analyze

 View Only

  • 1.  error importing excel files from directory node

    Posted 12-08-2020 04:51

    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.



  • 2.  RE: error importing excel files from directory node

    Employee
    Posted 12-08-2020 05:32

    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?



  • 3.  RE: error importing excel files from directory node

    Posted 12-08-2020 05:35

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

     

    and no sheets have been deleted 



  • 4.  RE: error importing excel files from directory node

    Employee
    Posted 12-08-2020 07:05

    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?