Module 21-core_Hybrid_Framework | Selenium Forum
M
Posted on 15/04/2016
Could you please tell me what was wrong in my code.I couldn't get it.It typing the coulumns extra time.

import java.util.Hashtable;

import org.testng.annotations.Test;

import com.hybrid.testng.framework.excel.utility.copy.Xls_Reader;

public class utility {
public static void main(String[] args) {


{
Xls_Reader xls=new Xls_Reader("C:\\Users\\sanjay\\maven\\hybrid\\src\\main\\resources\\AshishHybrid.xlsx");
int TestCaseRowNum=1;
String TestCaseName="TestA1";
while(!xls.getCellData("TestData",0,TestCaseRowNum).trim().toLowerCase().equals(TestCaseName.toLowerCase())){

TestCaseRowNum++;
}
System.out.println(TestCaseRowNum);


int colStartRowNum=TestCaseRowNum+1;
int dataStartRowNum=TestCaseRowNum+2;

//total no of rows
int rows=0;
while(!xls.getCellData("TestData",0,dataStartRowNum+rows).trim().equals("")){
rows++;
}
System.out.println("Total no of rows"+rows);

//total no of cols
int cols=0;
while(!xls.getCellData("TestData", cols,colStartRowNum ).trim().equals("")){
cols++;
}
System.out.println("Total no of cols"+cols);

//display data
//Object testData[][]=new Object[rows][1];//inside 1 the hashtable goes
int i=0;
for(int rNum=0;rNum<dataStartRowNum+rows;rNum++){
//for evryrow Iinsert put in hashtable ( created)
Hashtable<String,String> table=new Hashtable<String,String>();
for(int cNum=0;cNum<cols;cNum++){

String data=xls.getCellData("TestData", cNum, rNum);
String column=xls.getCellData("TestData", cNum,colStartRowNum );
System.out.println(column+"---"+data);


}
System.out.println(" --------------- ");

}
}
}
}
output--
1
Total no of rows4
Total no of cols5
Iteration---
RunMode---
Browser---
PortFolioName---
Case---
---------------
Iteration---TestA1
RunMode---
Browser---
PortFolioName---
Case---
---------------
Iteration---Iteration
RunMode---RunMode
Browser---Browser
PortFolioName---PortFolioName
Case---Case
---------------
Iteration---1.0
RunMode---y
Browser---Mozilla
PortFolioName---port A6
Case---case_ok
---------------
Iteration---2.0
RunMode---y
Browser---Chrome
PortFolioName---iter2
Case---case_Duplicate
---------------
Iteration---3.0
RunMode---N
Browser---Mozilla
PortFolioName---D3*
Case---case_ok
---------------
Iteration---4.0
RunMode---N
Browser---Chrome
PortFolioName---xx
Case---case_ok
---------------

M
Replied on 16/04/2016

what are you trying to do?