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 ?
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?
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
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....."
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 :(
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
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
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...
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.
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.
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)"
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.
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.
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 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 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
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?
📌 Apache POI Playlist Link: bit.ly/2RrngrH
✴ Checkout my other playlists: bit.ly/3gLIAVL
☕ Buy me a coffee: bit.ly/33ljBWc
Clearly you explained it please also keep advanced
Selenium videos
Thankyou 😊
I have covered all the topics in selenium, u r looking for anything special topic?
Framework Hybrid
Page object model
Very clearly explained. This helped me a lot . Thank you sir..
Glad to hear that
Thank you very much hyr. This is a very clear and understandable way thank you for it
Happy learning buddy 😊
You are explaining very good
Thanks buddy 😊
Love u bro u give confidence on this topics 🙌🙌🙌
Super buddy 😊
Thank you so much sir for made this video.
Happy learning buddy 😊
good video.. learnt lot of things from this video
Thanks buddy 😊
This helps me a lot in achieving my task. Thank you so much
Happy learning buddy 😊
As always nice explaination...👍
Keep watching
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 ?
Great ,can you please let us know how to find your vedios on all selenium topics
This is page you can refer buddy.
github.com/YadaGiriReddy/HYR-Tutorials
Thank you for doing this video
My pleasure!
Good explanation
Thankyou
Simply superb 👍
Thankyou 😊
Hi is there any video how to fetch data from database into excel. I want to data into 5excel.
Didn't create any buddy
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?
What error it is showing?
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
I hope this issue resolved. If not let me know buddy. You can mail me the screenshots on hyadagirireddytutorials@gmail.com
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....."
That is just a warning kind of thing buddy. So you can ignore that or try to implement the logging
@@HYRTutorials Thank you.
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 :(
That is not a blocker for us, so you can still continue with the operations
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
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
Hi, How so save the excel file using Selenium after write and add some rows?
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
@@HYRTutorials Thank you so much!!!
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...
Send me the screenshots on hyadagirireddytutorials@gmail.com
Hello sir
You are explaining very good, but I am getting error at write method.
Error please
i am getting null pointer exception here :
sheet1.getRow(0).createCell(0).setCellValue("xyz");
can u tell me why?
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.
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.
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)"
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.
Sir it shows error:
Exception in thread Awt-eventqueue-0 java.lang.noclass defFound
Please help
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.
How to make from json array
Iterate the json array and get the content of each json array element and then remaining steps are common
Hi bro how to add Sensitivity label to that excel
What is that sensitivity label?
@@HYRTutorials In Excel files Like Personal,Protected
No idea buddy
If we want to write data again in test. Xls then what we need to do
You can use the hssf related classes buddy
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..
are you sure you are using the same set of libraries?
@@HYRTutorials yes sir
here, i am getting NoClassDefFoundError......
how to solve it??
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
@@HYRTutorials I have added all the Jars and Jre, but still getting this type of error...I have no way to run the program
@@vishalregister655 send me the screenshot of your ide along with error and project structure on hyadagirireddytutorials@gmail.com
@@HYRTutorials I got solution of this... I added Jars in wrong place.. Now its working fine. Thanks
@@vishalregister655 cool
Sir first time runned successfully .After i reinstalled eclipse and run again error came.Name of error is EMPTY BITE ARRAY
Now working sir thankyou sir
Did you modify any libraries?
@@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
@@tarakaphani5006 sure buddy
java.io.IOException: Read-only file system can anyone help me with this??
can you give some more details on the issue?
@@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
is it intermittent issue or not at all running?
@@HYRTutorials no it is not running at all
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?
When I ran the test it displays "An illigal reflective access operation has occured". What I have to do
Never heard of that error buddy