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

[Sulabh Garg]

Hello Diane

You can try downloading a template of the table where you are loading the data using the Create Excel Template button?

You can use that template to load data and you will not face this issue when you received the excel file via email.

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[dianemiro]

Hi Sulabh,

The excel file I need to load is from an inbound email attachment coming in from external source.

Regards,
Diane

[shloke04]

HI,

I have faced this in past in my project and the issue was with lot of junk columns and headers present in the file received which we are trying to upload. Also by default when you try to upload a file ServiceNow takes Header and Row for import as "1".

There might be a possibility that the sheet you are trying to load has data present in different header and row and not in first header row.

Solution:

Copy paste the sheet data into a new sheet in Row number 1 and then try uploading. Error will be gone.

Else if you want the same sheet then make sure to update the Sheet Number and Header Row correctly as shown in Screenshot above before you click on Submit button to load the data.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[dianemiro]

Hello Shloke,

When I download the file and save a copy of the same excel file without modifying anything, I don't receive any errors in loading the data. But if it is coming in from the inbound email from an external source, I get the error. It is the same when I download the file and attach it directly on the data source.

Regards,
Diane