How to WRITE data into Excel file in Selenium WebDriver using Apache POI with Java language [2021]

[@chintadakiranraj7893]

Hi sir Can you tell me plz I have the pivot table If I enter the values in the one column cell the some columns in same row was filling automatically because of formule. But while entering values into column through Java code it is not reflecting the formule just it is filling the particular column only. But manually formule is apply but for the same sheet .it is not working through Java code how can we do that can you plz any hint or any suggestions plz

[@kshipra4504]

Is it possible to work with online excel data sheet in my selenium framework? I don't have ms office in my system.

[@yashaswibhav7742]

Sir i want to download this gode where to download

[@AJAUTOMATION]

I think it should be there in git repo, will push if not there...

[@yashaswibhav7742]

@@AJAUTOMATION no sir i didn't found there

[@yashaswibhav7742]

please push there sir

[@AJAUTOMATION]

github.com/ajautomation/Selenium_WebDriver/blob/master/src/test/java/testcases/WriteIntoExcel.java

[@nagalingabk5197]

getting error when the cell is not having any value (null). how to handle this error: Exception in thread "main" java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFCell.setCellValue(String)" because "cell" is null

[@AJAUTOMATION]

Try to create cell first before setting cell value. Try below - XSSFROW row=sheet.getRow(rownumber); XSSFCell cellToWrite=row.createCell(cellNumber); cellToWrite.setCellValue("value") ;

[@cherrypieofficial4969]

@@AJAUTOMATION you have already createcell in if condition. Is there anything else to do because when data is null in the sheet then only above exception throws .