I am getting below error while uploading excel for load data. com.glide.db.impex.datasource.DataSourceException: java.io.IOException: error in loading headers from the xlsx data source: The supplied data appears to be in the OLE2 Format. You are call

[Community Alums]

Hi @Ankur Bawiskar 

I am getting below error while uploading excel in load data.

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: error in loading headers from the xlsx data source: 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)

will you please help me?

excel file format is .xlsx.

[Ankur Bawiskar]

Hi,

seems the excel format is not parseable in ServiceNow

can you share what type of excel you are using and how it looks?

share error screenshot

Regards
Ankur

[Community Alums]

Yes Ankur, there might be excel file issue so I have copied the data into another excel and then loaded it. It is working fine now.

Thank you.

[Ankur Bawiskar]

@Vishwas 

Glad to know.

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[Nagaraj Tofin]

Hello Everyone,

I also encountered the same error; however, upon reevaluating the data that I had entered into the Excel, I discovered that it was not in the correct format. If Excel contains any incorrectly formatted data, then it generates such an error.

Solution:

• Maintain limited data during the creation of a new staging table.
• Ensure that all data is entered in the correct format, particularly for date and time.