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 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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)