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
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.
unfortunately the files are all in XLSB and i need to work on them like this...
I couldn’t find a way to work with binary excel files nor are there any plugins supporting this file type. I suggest you to discuss with your clients for any other possibilities else reach out to Appian support team if they can help with any alternative.