We are currently using "Import Excel to Database" smart service to upload XLSX or XLS files to write to Database in Appain 20.3
However, we are facing issue sometimes when uploading XLS file making the node to fail. There is no issue uploading with XLSX files though.
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)"
Has anyone come across above error or has any inputs on uploading .XLS file format without any issues in 20.3 version.
Discussion posts and replies are publicly visible
you are using the plugin: https://community.appian.com/b/appmarket/posts/excel-tools ?
Yes
I just came across this same error a short while ago -- I'll admit I've never heard of "OLE2 Format" of an XLS file until now. I'm not sure what your exact use case is, but I found that if I just save the XLS file as a CSV and instead use the Import CSV to Database v4 smart service, it works just as expected. It must be something to do with possible over-formatting or manipulation of the data in an "OLE2 Format" XLS, as opposed to the inherent simplicity of the formatting of data in a CSV.
Hope this helps! I'd love to hear if you ever found your own solution to this.