- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2023 11:28 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2023 01:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2025 11:38 PM
I found out that the problem in my case was the headers - as it says in the error message. I created an empty row below the header row, manualy wrote new headers, deleted the first row with original headers and saved the Excel file. Poof, it worked. We had some scandinavian letters in the headers and it seems ServiceNow doesn't like those at all.
So, as a summary:
- Just use basic characters in your headers
- Make sure the data is formatted correctly, especially when dates / times are entered