LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Acquisition - Excel File (importing single sheet)

    Employee
    Posted 03-25-2013 19:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: James M

    Hi All,

    I'm having issues importing single sheets in from a workbook. Below is the spec i'm using to import the second sheet, getting an error 'Contained Exception: The element type 'workbook' must be terminated by the matching end-tag "</workbook>"

    <workbook>
    <sheet/>
    <sheet index="2" />
    </sheet>
    <generatedFields>
    <field type="filename" />
    <field type="sheet" name="SheetInFile" />
    <field type="row" name="RecordNumber"/>
    </generatedFields>
    </workbook>

    Am I missing something pretty simple here? :S

    Thanks
    James


  • 2.  RE: Acquisition - Excel File (importing single sheet)

    Employee
    Posted 03-26-2013 06:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    You've got a <sheet> tag nested inside another <sheet> tag.
    All you need is:

    <workbook>
    <sheet index="2" />
    <generatedFields>
    <field type="filename" />
    <field type="sheet" name="SheetInFile" />
    <field type="row" name="RecordNumber"/>
    </generatedFields>
    </workbook>