-
Junior Member
Re: Is there any limit to number of columns in excel file, when reading it from scrip
HI..!
thanks for the reply,
Here is my full code.
public function Read_From_File(in dTable,in rowStart,in rowEnd)
{
#Section : Variables Declaration
auto sParamList; #string-Stores the list of parameters in the datatable
auto sKeyWord; #string-hold the keyword after the substring operation.
auto nParamNumber; #numeric- To hold the number of parameters in the data table
auto aFields[]; #array-To hold the fields and the keywords defined as parameters in the datatable
auto sData; #String that holds the string retreived from the data table
auto table_RowCount;
auto enum;
#ddt_open(dTable,0);
rc = ddt_open(dTable, DDT_MODE_READ);
ddt_get_parameters(dTable,sParamList,nParamNumber);
split(sParamList,aFields," "); # the separator is a tab
ddt_get_row_count(dTable,table_RowCount);
for(table_Row=1; table_Row <= table_RowCount ; table_Row ++)
{
ddt_set_row(dTable,table_Row);
report_msg("Checking Row With Row.No: " & table_Row);
for(enum = 2; enum <= nParamNumber; enum++)#reading only from column 2.
{
sKeyWord = substr(aFields[enum],1,7);#getting the the current column header.
sData=ddt_val(dTable,aFields[enum]);#getting the value of the cell of current row and column.
switch(sKeyWord)#depending on header, ill perform some actions.
{
case "BtnPrss":
button_press(sData);
break;
case "evalfnc":
eval(sData);
break;
.....Many more cases.
I am calling this function from main script like this.
Read_From_File("C:\myFolder\sheet1",1,5);
and in sheet1,
i am calling the same function again in the header evalfnc,
like,cell value = Read_From_File("C:\myFolder\sheet2",10,15); in sheet 2.
Here i am facing this problem,
I can read all the column headers from sheet1,(no limit.)
but inside sheet2,i can read only till column 'BK'.
I am not able to figure out why i am not able to read the headers after the column.
Does it have anything to do with calling the same function within the function??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules