Write a program to copy the odd rows from sheet1 of file1.xls to sheet1 of file2.xls

Interview Candidate
Aug 10th, 2006
5
1121

Showing Answers 1 - 5 of 5 Answers

narasing
Profile Answers by narasing

Oct 10th, 2006

sheet1 = "file1.xls";
sheet2 = "file2.xls";
rc1 = ddt_open(sheet1, DDT_MODE_READWRITE);
rc2 = ddt_open(sheet2, DDT_MODE_READWRITE);
if (rc1!= E_OK && rc1!= E_FILE_OPEN)
                   pause("Cannot open table?");
ddt_get_row_count(sheet1,n);
for(i = 1; i<= n; i ++)
{
                   ddt_set_row(sheet1,i);
                   a = ddt_val(sheet1,"inputa");
                   if (i mod 2 != 0)
                    ddt_set_val(sheet2,"result",a);
}
ddt_save(sheet1);
ddt_save(sheet2);
ddt_close(sheet1);
ddt_close(sheet2);