Hi Team,
Expression evaluation error at function 'readexcelsheetpaging': org.apache.pol.openxml4j.exceptions.OLE2NotOfficexmlFileException. 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)
Can anyone help on this to which function help to check format in excel
Thanks
Divya
Discussion posts and replies are publicly visible
You'll first need to make sure the data you're trying to read is standard Excel data in standard Excel format (being .xlsx with standard contents). Make sure it isn't really CSV data or old proprietary Excel (.xls) data.
Looks like file is older .xls format but function expects .xlsx