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?
Discussion posts and replies are publicly visible
I suppose that format which you are using is does not support by appian try with some other format.
We have a requirement to read xls file only.
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.