Error while fetching data from SharePoint

[MakAlteryx1]

Hi Community,

I am getting an error while fetching the data from an excel file using SharePoint (2.5.0) tool. The column contains dates but for few rows the information is either blank or '--', hence SharePoint is unable to fetch any data from an excel file.

Error : "Error: SharePoint Input (1): ("object of type <class 'str'> cannot be converted to int", 'Conversion failed for column Pay Date with type object')"