thank you for the details
even i tried the processallsheets and it worked well by putting try catch at the suggested lines.
now , my next query is, this works fine for
string values but what if the value is of type date.
how can i handle the date value.
when i check values for type as a mentioned below , i got it only for string type, which is s , for other column types such as date , number , i am getting NULL
here, i am getting s for celltype of type string and for other types, NULL