Excel tools plug in for XLSB files

Hello. I am having a trouble while using this plug-in. i am trying to get data from a cell in an excel file but the file is in the xlsb format and the plug in gives me the following error : Expression evaluation error at function 'readexcelsheetpaging': com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.

is there anyway to use this plugin for these files?

Or is there any work-around to get this same functionality? This is a step in my process model where the user has submitted the excel document. 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Is there a reason the user is using xlsb format instead of xlsx. In general the compatibility of xlsb files is lower so may be Excel Tools is not able to work with it. The plugin works well with xlsx or csv files so give a try with any of these formats and see if issue persists! 

    Also, AFAIK there are no plugins to work with xlsb format. So going with xlsx or csv seems the only way to go ahead.

Reply
  • 0
    Certified Lead Developer

    Is there a reason the user is using xlsb format instead of xlsx. In general the compatibility of xlsb files is lower so may be Excel Tools is not able to work with it. The plugin works well with xlsx or csv files so give a try with any of these formats and see if issue persists! 

    Also, AFAIK there are no plugins to work with xlsb format. So going with xlsx or csv seems the only way to go ahead.

Children