Type mismatch error - vijay44 - 01-22-2010
Hi,
I am trying to retrieve the data from the excel sheet.Iam using the below code
Code: sPrevalencePopularity=datatable.Value("PrevalencePopularity",oSheetName)
Here prevalencepopularity is the column in the datasheet.
when i run the script, its giving type mismatch error
prevalence
i think its only identifying prevalence.
any help will be really appreciated.
Regards;
vijay
RE: Type mismatch error - ambareesh - 01-22-2010
keep sheetname also in quotes.
i.e., Code: sPrevalencePopularity=datatable("PrevalencePopularity", "oSheetName")
dont forget to set the row before using this statement.
The code will be
Code: Datatable.setcurrentrow(1)
sPrevalencePopularity=datatable("PrevalencePopularity", "oSheetName")
|