Type mismatch error

[vijay44]

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

[ambareesh]

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