Selenium Web driver

publicclassExcelLib{
publicstaticfinalStringfilePath=".\\testData\\testData.xlsx";
publicstaticStringreadExcelData(introwNum,intcellNum)
{
Stringdata="";
try{
Workbookwb=WorkbookFactory.create(newFileInputStream(newFile(filePath)));
data=wb.getSheet("Sheet1").getRow(rowNum).getCell(cellNum).getStringCellValue();
}
catch(EncryptedDocumentExceptione){
}
catch(InvalidFormatExceptione){
}
catch(FileNotFoundExceptione){
}
catch(IOExceptione){
}
returndata;
}
publicstaticvoidsetExcelData(introwNum,intcellNum,Stringdata){
try{
Workbookwb=WorkbookFactory.create(newFileInputStream(newFile(filePath)));
Cellc=wb.getSheet("Sheet1").getRow(rowNum).createCell(cellNum);
c.setCellType(Cell.CELL_TYPE_STRING);
FileOutputStreamfos=newFileOutputStream(newFile(filePath));
c.setCellValue(data);
wb.write(fos);
}
catch(EncryptedDocumentExceptione){
}
catch(InvalidFormatExceptione){
}
catch(FileNotFoundExceptione){
}
catch(IOExceptione){
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kapi Shivhare10y ago
publicclassExcelLib{
publicstaticfinalStringfilePath=".\\testData\\testData.xlsx";
publicstaticStringreadExcelData(introwNum,intcellNum)
{
Stringdata="";
try{
Workbookwb=WorkbookFactory.create(newFileInputStream(newFile(filePath)));
data=wb.getSheet("Sheet1").getRow(rowNum).getCell(cellNum).getStringCellValue();
}
catch(EncryptedDocumentExceptione){
}
catch(InvalidFormatExceptione){
}
catch(FileNotFoundExceptione){
}
catch(IOExceptione){
}
returndata;
}
publicstaticvoidsetExcelData(introwNum,intcellNum,Stringdata){
try{
Workbookwb=WorkbookFactory.create(newFileInputStream(newFile(filePath)));
Cellc=wb.getSheet("Sheet1").getRow(rowNum).createCell(cellNum);
c.setCellType(Cell.CELL_TYPE_STRING);
FileOutputStreamfos=newFileOutputStream(newFile(filePath));
c.setCellValue(data);
wb.write(fos);
}
catch(EncryptedDocumentExceptione){
}
catch(InvalidFormatExceptione){
}
catch(FileNotFoundExceptione){
}
catch(IOExceptione){
}
}
}
Ipsita Sethi10y ago
I want code to read and also to write.
Abhishek Arora10y ago
Do you want to read data from excel file or you want to write data into excel file.