Selenium Web driver

Question

How to upload an Excel file using selenium webdriver.

Kapi Shivhare · Answer

public class ExcelLib{ public static finalStringfilePath= ".\testData\testData.xlsx" ; public static StringreadExcelData( int rowNum, int cellNum) { Stringdata= "" ; try { Workbookwb=WorkbookFactory.create( new FileInputStream( new File(filePath))); data=wb.getSheet( "Sheet1" ).getRow(rowNum).getCell(cellNum).getStringCellValue(); } catch (EncryptedDocumentExceptione){ } catch (InvalidFormatExceptione){ } catch (FileNotFoundExceptione){ } catch (IOExceptione){ } return data; } public static void setExcelData( int rowNum, int cellNum,Stringdata){ try { Workbookwb=WorkbookFactory.create( new FileInputStream( new File(filePath))); Cellc=wb.getSheet( "Sheet1" ).getRow(rowNum).createCell(cellNum); c.setCellType(Cell.CELL_TYPE_STRING); FileOutputStreamfos= new FileOutputStream( new File(filePath)); c.setCellValue(data); wb.write(fos); } catch (EncryptedDocumentExceptione){ } catch (InvalidFormatExceptione){ } catch (FileNotFoundExceptione){ } catch (IOExceptione){ } } }

Ipsita Sethi · Answer

I want code to read and also to write.

Abhishek Arora · Answer

Do you want to read data from excel file or you want to write data into excel file.

Selenium Web driver

Answers (3)