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')"