Getting "Unable to load headers" when doing load data from xlsx

MongGu
Tera Guru

Hello,

 

I was following instructions for Application Development Fundamentals Lab 7.1, which was to import excel data to create table and do mapping. 

 

When loading excel data using "System Import Sets" -> "Load Data", I am keep getting the following error: "com.glide.db.impex.datasource.DataSourceException: Unable to load headers from the XLSX data source" 

 

Header Row is set to 1, I followed exactly the same thing as the provided demo video for the lab but unlike a demo, it is giving me that error. 

 

Does anyone knows why and how to fix this?

 

MongGu_1-1676402587695.png

 

 

MongGu_2-1676402605844.png

 

1 ACCEPTED SOLUTION

MongGu
Tera Guru

Hi All,

 

Found out that the error only happens on the PDIs.

View solution in original post

10 REPLIES 10

SatyakiBose
Mega Sage

Hello @MongGu 

Can you please verify that the column header in the excel sheet:

  • does not contain special characters
  • is in english
  • does not have any URL
  • formatted correctly

Hi @SatyakiBose 

 

MongGu_0-1676575515689.png

 

Thanks. Here is the screenshot of the excel. I verified everything and it seems that nothing is wrong but still I was unable to import data, showing me the same error. I didn't change anything from what nowlearning.servicenow provided me for the lab. Still not sure why the error is popping up. 

Manoj R Zete
Tera Expert

Hi @MongGu ,

 

Please make sure excel file is properly populated.

 

  • Your Excel dataset needs to be well formed;
    1. The Excel spreadsheet should be in Excel 97-2003 format and have a .xls extension.
    2. The Excel workbook should only contain 1 worksheet.
    3. The 1st row is the header row and should contain the column names, should not contain special character.
    4. Data must be contiguous, i.e. no blank columns within the data.
  • If the dataset appears OK, but is still not loading, export it to CSV and open the CSV and save it an a new Excel file.

Regards

Manoj

Hi @Manoj R Zete 

 

MongGu_0-1676575949161.png

 

Thanks for the reply. Here is the screenshot of the excel that nowlearning.servicenow provided me for the lab. I didn't change anything. 

 

1. I tried saving as .xls extension but still gave me an error. This time, not even the details of the error message was shown. 

2. Yes. It only has one sheet.

3. I verified the format was correct.

4. I verified this also.

 

I also tried exporting as CSV, opened and save it as a new Excel file but this still gave me the same error as original.