Type mismatch error - Printable Version

Type mismatch error - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Type mismatch error (/Thread-Type-mismatch-error--3005)

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