Contributions
Doubt
CAN ANYONE OF YOU HELP ME IN DEMOS FOR THEBELOW MENTIONED TOPICS Demo excel (POI.jar) ,Read and Write to file(txt,excel) ,JDBC connections ,Contains(complex) and more demos.,Github and Jenkins,REST SV Can anyonecheck whether the below code is correct for reading the data from excel and write it back to excel //read data from excel //helps to fetch all the files import jxl.* //to read from excel Workbook wb= Workbook.getWorkbook(new File("C:\\Users\\divya_mohan04\\Desktop\\DataToBeRead.xls")); //either index of sheet of name of sheet within double quotes can be given//using object of workbook we are accesing the values Sheet sh = wb.getSheet("Sheet1") //how many data are there in excel//rc-row count//cc-column count rc = sh.getRows(); cc = sh.getColumns(); log.info "Row Count" : rc log.info "Row Count" : cc for(i=1;i<rc;i++) { for(j=0;j<cc;j++) { def num1 = testRunner.testCase.getTestStepByName("Properties") Cell var = sh.getCell(i,j) log.info var.getContents() } } //write data to excel //In order to write anything we need to first create a writable workbook as below which creates the workbook object. WritableWorkbook workbook = Workbook.createWorkbook(new File("c:\\Testing\\myfile.xls---give location")) //We can also use the existing excel sheet and write the data into excel sheet. //But before doing write operations we need to make sure to take the copy of the original file //and then perform the write operations. The below code is the sample code. Workbook workbook = Workbook.getWorkbook(new File("testSampleData.xls")); WritableWorkbook workbookCopy= Workbook.createWorkbook(new File("testSampleData.xls"), workbook); //Now access the sheet from the workbook which is copied from the original. WritableSheet wSheet = workbookCopy.getSheet(0); //now we have the worksheet-so now we have to pass the data into excel by mentioning the column number and row number WritableSheet wshTemp = wwbCopy.getSheet(strSheetName); Label label = new Label(iColumnNumber, iRowNumber, strData); wshTemp.addCell(label);602Views0likes0Comments