How to Create Excel File using Apache POI | Selenium WebDriver |

[@HYRTutorials]

📌 Apache POI Playlist Link: bit.ly/2RrngrH ✴ Checkout my other playlists: bit.ly/3gLIAVL ☕ Buy me a coffee: bit.ly/33ljBWc

[@palleanusha6616]

Clearly you explained it please also keep advanced Selenium videos

[@HYRTutorials]

Thankyou 😊 I have covered all the topics in selenium, u r looking for anything special topic?

[@sagarrokade7651]

Framework Hybrid

[@sagarrokade7651]

Page object model

[@yugandharbabuchimata36]

Love u bro u give confidence on this topics 🙌🙌🙌

[@HYRTutorials]

Super buddy 😊

[@m.gowriswarnarul1580]

Very clearly explained. This helped me a lot . Thank you sir..

[@HYRTutorials]

Glad to hear that

[@indiantourism975]

You are explaining very good

[@HYRTutorials]

Thanks buddy 😊

[@kishoresrinivas2104]

Thank you very much hyr. This is a very clear and understandable way thank you for it

[@HYRTutorials]

Happy learning buddy 😊

[@HanamantappaRP]

good video.. learnt lot of things from this video

[@HYRTutorials]

Thanks buddy 😊

[@shikhagarewal5310]

This helps me a lot in achieving my task. Thank you so much

[@HYRTutorials]

Happy learning buddy 😊

[@C.Sakthivignesh]

Thank you so much sir for made this video.

[@HYRTutorials]

Happy learning buddy 😊

[@tgrakesh8gmail]

As always nice explaination...👍

[@HYRTutorials]

Keep watching

[@poojatejuthupakula8381]

Simply superb 👍

[@HYRTutorials]

Thankyou 😊

[@vijaygurusamy4055]

Good explanation

[@HYRTutorials]

Thankyou

[@anil.adusupalli]

Great ,can you please let us know how to find your vedios on all selenium topics

[@HYRTutorials]

This is page you can refer buddy. github.com/YadaGiriReddy/HYR-Tutorials

[@gs-rc3eq]

Thank you for doing this video

[@HYRTutorials]

My pleasure!

[@SnehilAgrawal-x6h]

Hi is there any video how to fetch data from database into excel. I want to data into 5excel.

[@HYRTutorials]

Didn't create any buddy

[@kirankumarj9485]

If i want to filter the records , For example Excel sheet has two column Ordernum and Status . If Status is equal to Shipped if should move to another sheet . Is this possible by using apache Poi ?

[@krutikashah5476]

Simply perfectly explanations but there is some issue with my system! when i wrote prog. with XSSFWorkbook - new version.. its not working anymore and showing an error.! can u plz help me? what i'm gonna do in that case?

[@HYRTutorials]

What error it is showing?

[@thecarhouse858]

I want to add data to the present file like test is created and I want to add new data to test how is it possible

[@HYRTutorials]

Instead of creating a new file try to utilise the same file. If you watch this video and next video in how to read then you will get the idea. Use the fileoutputstream for accessing the existing file and then add your data. Post that use the fileoutputstream to make the changes to the file

[@shravs2016]

Hi, Thank you so much for the video. I am new to automation, just started learning. I have a query, I followed the same steps as mentioned in the video. On running, i am getting error, excel file is not opening. Can you pls help me to resolve this? Error: Could not find or load main class com.ReadandWriteExcel.Excelfiletest Caused by: java.lang.ClassNotFoundException: com.ReadandWriteExcel.Excelfiletest

[@HYRTutorials]

I hope this issue resolved. If not let me know buddy. You can mail me the screenshots on [e-mail]

[@helio363]

Hi, Your videos are so informative. When I tried your code I got this error in the console "Error Status logger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimplerLgger to log to the console....."

[@HYRTutorials]

That is just a warning kind of thing buddy. So you can ignore that or try to implement the logging

[@helio363]

@@HYRTutorials Thank you.

[@gilsonsouza8159]

Hi, How so save the excel file using Selenium after write and add some rows?

[@HYRTutorials]

In this video, I have covered that part. Manually we save the file after entering some data but in automation we don't perform save operation explicitly. Fileoutputsttream nd workbook takes care of that

[@gilsonsouza8159]

@@HYRTutorials Thank you so much!!!

[@madhavilatha1996]

Hello sir You are explaining very good, but I am getting error at write method.

[@HYRTutorials]

Error please

[@shobhapasula3073]

If we want to write data again in test. Xls then what we need to do

[@HYRTutorials]

You can use the hssf related classes buddy

[@jijoeype9602]

Hi bro how to add Sensitivity label to that excel

[@HYRTutorials]

What is that sensitivity label?

[@jijoeype9602]

@@HYRTutorials In Excel files Like Personal,Protected

[@HYRTutorials]

No idea buddy

[@RohanPanchu]

An Issue like this pop's up on the console.I added the Log4j2 but it still appears as this help, please !!!! ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...

[@HYRTutorials]

Send me the screenshots on [e-mail]

[@santhoshinilakkavathri3199]

i am getting null pointer exception here : sheet1.getRow(0).createCell(0).setCellValue("xyz"); can u tell me why?

[@HYRTutorials]

This could be because of empty row. Empty in the sense the row is not created actually. Manually you can see the row but from library, it only accept the rows which were created.

[@HYRTutorials]

I think here you want to enter the text in first row first cell am I correct? Without creating the row you are trying to get the row. That's the issue. So before getting the first row, create it. Later you can get it.

[@millenniumchowdhury6395]

How to make from json array

[@HYRTutorials]

Iterate the json array and get the content of each json array element and then remaining steps are common

[@antonedisatrio8661]

ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console... please help im stuck :(

[@HYRTutorials]

That is not a blocker for us, so you can still continue with the operations

[@madhavilatha1996]

Hello sir, I am getting error at workbook.write()...it is not recognizing .not giving options in write method like you...It is asking only one write method,write (Outputs team).. What I have done mistake.please help me..and I am not able workbook.close()., also getting error..

[@HYRTutorials]

are you sure you are using the same set of libraries?

[@madhavilatha1996]

@@HYRTutorials yes sir

[@vishalregister655]

here, i am getting NoClassDefFoundError...... how to solve it??

[@HYRTutorials]

That's a general error, try restarting the Eclipse IDE and make sure the jar files are added to the project and jdk is added to the project

[@vishalregister655]

@@HYRTutorials I have added all the Jars and Jre, but still getting this type of error...I have no way to run the program

[@HYRTutorials]

@@vishalregister655 send me the screenshot of your ide along with error and project structure on [e-mail]

[@vishalregister655]

@@HYRTutorials I got solution of this... I added Jars in wrong place.. Now its working fine. Thanks

[@HYRTutorials]

@@vishalregister655 cool

[@adityanetalkar2649]

Hi, i followed the code but when i execute iam getting this error: "Exception in thread "main" java.lang.NullPointerException at Maven_Practise.MavenPractise.WriteExcel.main(WriteExcel.java:19)"

[@HYRTutorials]

Null pointer exception is a very common exception and it comes when you are performing any operation on the null value. So if you can paste your code then I can help you in identifying the issue.

[@abdulhanan1147]

Sir it shows error: Exception in thread Awt-eventqueue-0 java.lang.noclass defFound Please help

[@HYRTutorials]

This is not related to Apache POI I guess. Just restart the IDE and make sure you are executing the correct java file by right clicking on that. Sometimes if we use the run button present in the tool bar then we may get this kind of exceptions.

[@tarakaphani5006]

Sir first time runned successfully .After i reinstalled eclipse and run again error came.Name of error is EMPTY BITE ARRAY

[@tarakaphani5006]

Now working sir thankyou sir

[@HYRTutorials]

Did you modify any libraries?

[@tarakaphani5006]

@@HYRTutorials now working sir, your videos are understanding very much compare to all free video channels. In this channel not there some topics like api testing ( mobile testing), git, gira, Jenkins, cucumber, post man. Sir, please create videos for these topics

[@HYRTutorials]

@@tarakaphani5006 sure buddy

[@harshitgupta2868]

java.io.IOException: Read-only file system can anyone help me with this??

[@HYRTutorials]

can you give some more details on the issue?

[@harshitgupta2868]

@@HYRTutorials i had applied the same code as yours but it is giving me error READ ONLY SYSTEM and sometimes it shows FILE NOT FOUND EXCEPTION and I had given the permission through Android manifest

[@HYRTutorials]

is it intermittent issue or not at all running?

[@harshitgupta2868]

@@HYRTutorials no it is not running at all

[@HYRTutorials]

1. Which path you are providing either relative path or absolute path of file? 2. While writing anything into file, the file shouldn't be in open condition. it should be closed. 3. are there any specific setting you need to perform in android studio?

[@srilakshmi5215]

When I ran the test it displays "An illigal reflective access operation has occured". What I have to do

[@HYRTutorials]

Never heard of that error buddy