Unable to load headers from the XLSX data source ( scheduled import job: XXXXX)

[pardhiv]

We have a data Import that is failing only in Production with the following error on the Import set :

Unable to load headers from the XLSX data source ( scheduled import job: XXXXXX)

whereas , the front end when excel is loaded throws the following error.

Error Message

Either the attached spreadsheet does not contain the necessary information to complete this Request or it took longer than expected to process. Please refresh this list to see if the Request has been created. if it was not created, then please validate your XLS file and resubmit.

The excel file has data in sheet 7 and header row 1 as data source expects.

[Vishnu Prasad K]

Hi Pardhiv,

If you are using 'Load Data' option to attach and import the excel, make sure that the value for 'Header row number' is 1 and that the excel you attach has the first row populated.

[pardhiv]

Please check the 1st screenshot , Data is as expected?

[Shui]

Hi Pardhiv,

Are you able to solve the issue? I encountered the same error when I tried to deploy to another instance, Unable to load headers from the XLSX data source ( scheduled import job: XXXXXX). In my case, the import completed with error and nothing was loaded.

Thank you,

Shui

[Sumit Rathod4]

Hello,

Even I am getting this error, how did you got it resolved?

Please answer.

Regards,

Sumit R.