I have extracted the data from a table present in the web site.
usually this table will have 5 columns with minim of 1 row. n all values filled
but this time i faced a issue it has one row and values are filled only for 3 columns as below
the once which r marked in red has value in yellow usually will have value but this time not there.
and when i did debug
i got it as below, its a scraped data now i took it in to the data table
[Vessel, Port of Loading, Departure Date
I am having a big project. in this i have to take these all 5 values and enter it in excel at different places so i had written the following code.
Well now its throwing an error saying column 4
Cannot find column 4 - from exception i get it as email
NOTE: Let the table have 1 value or 2 values or all the values. i have to enter them in to the excel file. but the above code is not working as expected
Please help me to fix it up