Error in Loading Data from .xlsx

[dianemiro]

Hi Everyone,

I am trying to import a .xlsx file which is coming from an email. But when I try to load the data, I get an error message: "com.glide.db.impex.datasource.DataSourceException: java.io.IOException: error in loading headers from the xlsx data source: null"

If I open the .xlsx file and save a copy, then load the data, I don't get the error message. I also noticed that the size and headers for both files are different. Can anyone point me to where the issue is coming from? Thank you!

Regards,
Diane

[Dave105]

Hi Diane,

Is it possible that when you are saving your copy is it then a .xls file not xlsx? Don't think ServiceNow likes .xlsx files

Regards

Dave 

[dianemiro]

Hi Dave,

I was saving it as .xlsx and it is also .xlsx for the file coming in from the inbound email.

Regards,
Diane

[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.

[GS10]

Hi Dianemiro, I am also facing the similar issue. Did you get the solution to fix it. Regards - Gaurav