Have to verify against excel spread sheet where report descriptions are stored . please guide \"how to proceed?

Have to verify against excel spread sheet where report descriptions are stored . please guide \"how to proceed?

A list box which is displaying report names and below that there is a multi line text box provided which is displaying the description of the report corresponding to each report. Able get all the descriptions by using below for loop. But have to verify against excel spread sheet where report descriptions are stored . please guide \"how to proceed?\"


list_get_info(\"Listbox1\",\"count\",count);

for(num = 1; num < count; num++)

{

row = num + 1;

list_select_item(\"Listbox1\", \"#\"&num);

list_get_info(\"Listbox1\",\"value\",val);

report_msg(val);

edit_get_text(\"Textarea1\",s) ;

report_msg(s);

}


#Open the excel spread sheet

# suppose spread sheet having 2 fields, Report_name and report_des

table = \"E:\\test\\Datadriven\\default.xls\";

rc = ddt_open(table, DDT_MODE_READ);

if (rc!= E_OK && rc != E_FILE_OPEN)

{

#loop the list box items

for(num = 0; num < count; num++)

{

list_get_info(\"Listbox1\",\"value\",val);

ddt_get_row_count(table,table_RowCount);

for(table_Row = 1; table_Row <= table_RowCount; table_Row ++)

{

ddt_set_row(table,table_Row);

report_name = ddt_val(table, \"report_name\");

if ( val == report_name)

{

report_des = ddt_val(table, \"report_des\");

# Compare the report description

}

}

}

}


By:UMANG
Date:2001-02-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related TESTING Subjective Links

TESTING Subjective interview questions and answers for experienced and fresher