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;
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??