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.  Excel Node - Unable to Read (encoding error)

    Employee
    Posted 08-28-2017 10:24

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

    Originally posted by: jpstory

    Hi All

    A error message is generated when Excel Node tries to read a xls file.

    The original input data does NOT have headers, so I have to set up the header under Optional tab:
    <workbook>
    <sheet index="1">
    <field name="Field_1" />
    <field name="Field_2" />
    <field name="Field_3" />
    <field name="Field_4" />
    </sheet>
    </workbook>

    Here's the error message:
    "Invalid byte 2 of 2-byte UTF-8 sequence."

    Alternatives tried:
    Copy the entire file and paste as value to a new blank Excel file. This did not work, the issue still persit.

    Can you advise what caused the issue, it looks just like a normal excel file and I can open it up in Excel without any problems.

    Is there a fix for this, thanks!


  • 2.  RE: Excel Node - Unable to Read (encoding error)

    Employee
    Posted 09-11-2017 09:30

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

    Originally posted by: residnt

    have you tried setting the Default type to unicode on the Optional Tab?