Below is the flowchart of the issue that is arising, I am trying to transport excel data to a list on sharepoint under a site. The excel spreadsheet has numerous headings that I am trying to transport including 'Project Name', however it seems to be failing and I am not sure why. I have checked if the sites and list addresses are correct which they are so not sure what the issue presists.
The output of the code is here: