Selenium Web driver

Question

How to upload an Excel file using selenium webdriver.

Kap 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 cellNumStringdata){ 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.