Forum Discussion
Sandeepss
Occasional Contributor
Hi
I have used your code only and done some R&D finally i got your expected result here belowo is code.
import jxl.*;
import jxl.write.*
Workbook workbook = Workbook.getWorkbook(new File("d:\\NewExcel.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("d:\\NewExcel.xls"),workbook);
Sheet sheet1 = copy.getSheet("Sheet4");
WritableSheet sheet2 = copy.getSheet("Sheet1");
CL = 0;
rows = sheet1.getRows();
for( tc_row in 1..rows-1){
WritableCell tmpA = sheet1.getCell(CL,tc_row);
String s1 = tmpA.getContents();
log.info("$s1")
Label label = new Label(CL,tc_row,s1);
sheet2.addCell(label);
}
copy.write();
copy.close();
workbook.close();
I have also one query plz help me out in that...
Regards,
Sandeep S S
I have used your code only and done some R&D finally i got your expected result here belowo is code.
import jxl.*;
import jxl.write.*
Workbook workbook = Workbook.getWorkbook(new File("d:\\NewExcel.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("d:\\NewExcel.xls"),workbook);
Sheet sheet1 = copy.getSheet("Sheet4");
WritableSheet sheet2 = copy.getSheet("Sheet1");
CL = 0;
rows = sheet1.getRows();
for( tc_row in 1..rows-1){
WritableCell tmpA = sheet1.getCell(CL,tc_row);
String s1 = tmpA.getContents();
log.info("$s1")
Label label = new Label(CL,tc_row,s1);
sheet2.addCell(label);
}
copy.write();
copy.close();
workbook.close();
I have also one query plz help me out in that...
Regards,
Sandeep S S
raviteja143
7 years agoNew Contributor
will u please explain the above code.i am beginner in soap ui pro
Related Content
- 2 years ago
- 2 years ago
Recent Discussions
- 3 days ago