public function get_xls_line(in filename, in row) { auto line_val,params,param_num,i; static parama[]; ddt_close_all_tables(); ddt_open(filename,DDT_MODE_READ); # open excel file ddt_get_parameters(filename,params,param_num); # get content of the 1st line (WR recognizes as "Parameters") if (row==0) return params; # return this line, if requested split (params,parama,"\t"); for(i=1;i<=param_num;i++) # or get any other line line_val = line_val&"\t"&ddt_val_by_row(filename, row, parama[i]); ddt_close(filename); return line_val; # and return } printf get_xls_line("c:\\temp\\data.xls",1); # test