Unable to load the data from data source using mid server

[Abhilasha G T]

Hi Team,

We are using mid server to run the PowerShell script that script fetch excel file from particular folder and sent it to ServiceNow data source where as when click related link to load that data into staging table i got the error ,

getting a error like below,

com.glide.db.impex.datasource.DataSourceException: Unable to load headers from the XLSX data source

where as when i do manually to attach that excel file to that data source , data is loading into the staging table.  

how to troubleshoot this?

Regards,

Abhilasha G T

[Roshan Tiwari]

Check the headers correctly, sometimes via script few lines or whitespaces will be added automatically.