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

[MongGu]

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 · Accepted solution]

Hi All,

Found out that the error only happens on the PDIs.

[Mika Latvala]

Not true, I'm just facing the same error in our sub-prod instance. Funny is, the previous data load worked but now when trying to refresh the data, it doesn't work.

I also noticed that when I upload the file in the data source, then download it back, Excel is unable to open it anymore. Sometimes you can also see in the data source that the "Header row" has changed to 0 (zero). Even if changing it back to 1, will not solve the issue.

The very same file works in another instance that was cloned a week ago.

[ThulasiramP]

Hi mongGu

is this issue resolved? am also facing the same issue.

[Rajiv Handa]

Another reason for this error could be too many records in the file. 

I had 23k+ records in the Excel file and was getting the same error repeatedly. Then, I split up my data into a bunch of 4k records and was successfully able to load it. 

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