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