Hi
Could you please check why I am unable to print rows and cols.What was wrong in my code
package com.utility.data;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
public class DataManager {
public static void main(String[] args) {
String testName="GmailTest";
Xls_Reader xls=new Xls_Reader("C:\\Users\\sanja\\maven\\com.flipkart\\Data\\SuiteA.xlsx");
int testStartRowNum=1;
while(!xls.getCellData("Data",0,testStartRowNum).equals(testName)){
testStartRowNum++;
}
System.out.println("TestCase start fron row--"+testStartRowNum);
int colStartRowNum=testStartRowNum+1;
int dataStartRowNum=testStartRowNum+2;
int rows=0;
while(!xls.getCellData("Data",0,dataStartRowNum+rows).equals("")){
dataStartRowNum++;
}
System.out.println("Total no of rows"+rows);
int cols=0;
while(!xls.getCellData("Data",cols,colStartRowNum).equals("")){
colStartRowNum++;
}
System.out.println("Total no of cols"+cols);
for(int rNum=2;rNum<dataStartRowNum+rows;rNum++){
for(int cNum=0;cNum<colStartRowNum;cNum++){
String data=xls.getCellData("Data", cNum, rNum);
System.out.println(data);
}
}
}
}
o/p is
TestCase start fron row--1
Total no of rows0
Total no of cols0
RunMode
Browser
UserName
Password
Y
mozilla
yaminijkothala@gmail.com
124555
N
mozilla
jyosh.maddy@gmail.com
1999999
N
mozilla
jyosh.maddy@gmail.com
19999999999999
Thank you in advance.
