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

Comments

3 comments

  • 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

    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.