Facing issue while reading 97-2003 version XLS file

Question

I need to read and save data from XLS document. I tried using "Export excel to Database" smart service, but it is giving error "???The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)???".
I also tried to convert the XLS document to CSV document using the "Convert excel to CSV" smart service and also tried to read XLS file in expression rule using fn!readexcelsheetpaging but still getting same error.
Is there any way we can read XLS document?

mikes0011 · Accepted Answer

The old format (prior to xlsx) uses a proprietary file format, which I'm not sure there's any way to read within Appian (though you could search in case anyone's made some specialized plug-in for it).  Otherwise I'd suggest opening the file in Excel and saving it as .xlsx format.

harshj0001 · Answer

I suppose that format which you are using is does not support by appian try with some other format.

Sign up

Login with SSO

Login to the community

Login with SSO