How to Read and Write Excel File in Selenium

This video will talk about How to Read and Write excel file in Selenium WebDriver using Java and Apache POI.

In Automation, we have to take data from an external source like excel file, CSV file, database etc. In this tutorial, we will discuss How to Read and Write excel file in Selenium using Apache POI.

We will use the same approach in data-driven framework.

Please find the code in below mentioned Link.

Please Share, Support and Subscribe and let’s spread the knowledge.

[Anwar-Mian]

Nice and comprehensive demo in about six minutes. Excellent job.

[sahilmehta]

your video is just awesome covering and clearing each respective topics in short....

[joshijoshi]

Thanks for the video. pls bring more more videos with different examples.

[raju]

Waiting for your next video.... Thanks

[rajeshdevan]

Hi Bro thanks for your video you explained nice but in my pgm the CELL_TYPE_STRING this is not coming i did same code as per your video and added Apache poi properly but why cell type is not coming but in your pgm how you got i did exactly as per your video but y pls can you solve this prob? and This is not a right way for a tutorial. Write the code in real time and explain side by side. Nobody is going to understand the already written code.

[imjaga]

Exception in thread "main" The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)
at
at
at
at
at

[ganeshmanjunath]

Thanks for the video.
I think it should be
We can't use getCell and setCellValue if the cell has null value.

[Santhosh_Life]

hey bro, hope you doing good. i dont have excel in my Mac . can you jus guide me how can i read and write data from numbers in mac ??

[SaurabhSingh-iiql]

Thanks very much Santhosh. Very well explained. May be you can write the code in real time and explain

[priyasai]

Thank you so much Bro. very nice explanation. but the video could be little longer with some more details.

[sphurtibhosale]

How to handle if blank cell is there it shows null pointer exception

[sainiranjan]

Hello Santhosh, As I run on local I have no issues but when I upload to Azure DevOps (CI/CD) and run remotely, build failed with below errors. I was wondering why Azure DevOps failing to download the packages? Any suggestion please!

[INFO] Compiling 32 source files to
[INFO]
[ERROR] COMPILATION ERROR :
[INFO]
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[8, 35] package org.apache.poi.ss.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[9, 37] package org.apache.poi.xssf.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[10, 37] package org.apache.poi.xssf.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[18, 9] cannot find symbol
symbol: class XSSFWorkbook
location: class
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[20, 9] cannot find symbol
symbol: class XSSFSheet
location: class
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[31, 34] cannot find symbol
symbol: class XSSFWorkbook
location: class
[INFO] 6 errors

[maddyrao]

I'm getting classnotfoundexception at line number 27 in your code...not able to remove error help me...but no warnings in code

[bijenderprasad]

Not Sure how your code is working but correct insert line should be


{
System.out.println(value);

}
else
{ //System.out.println(value);

}



You Used getCell(2) but that is not working for me

[khosruvai]

didn't see any selenium in this video..

[ramsaibhogi]

bro cpy paste the code in comments bro

[arungupta]

This is not a right way for a tutorial. Write the code in real time and explain side by side. Nobody is going to understand the already written code.

[ajeetsingh]

Sale ye to bata ki poi ko eclipse me kaise add karte hain