Hello All, Sharing the latest Excel Util - Xls_Reader class used to perform read/write operations on Excel files. This util is having all the latest dependencies as per Apache POI api - 4.x.x version. You can get this util from my GIT Repo: github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java
4 Years gone, but the quality still remains unaffected... Really awesome explanations in simple language... now I am ready for switching thank you @naveen
Naveen....you are of the best teachers I have ever came across.you can make a even 7th standard student expert in selenium and that's the kind of explanation u give.....thanks a lot sir for the bottom of my heart...
Naveen your videos are just amazing. Your way to explain each and every thing is just super. You have refined every term in a simple way. Thank you so much. With your videos, my interest to learn automation testing is boosting up.
@2:26 Closing Excel file to keep away from corrupting. @3:18 A code to add column in Excel file. @3:54 A code to enter some data into a single cell. @6:48 Running the code. @10:24 Creating a class under package which is consisting Datadriven Test. @10:54 A code to access Excel sheet. @11:19 A code to add new Excel sheet and giving name to it @11:55 Running the code. @12:22 A code to check particular Excel sheet is present or not. If not, then add it. @13:50 Running the code. @15:00 A code to print the count of columns belonging to particular Excel sheet. @16:12 Running the code. @16:42 A code to print a row number based on particular cell value. @18:38 Running the code.
Hi, great tutorial. But when I enter any value like Zip code(411001) in excel it will give me the return value in code as (411001.0). How we will solve this issue as I have number of value in excel which are in int format. Please help me where the code need to add or logic need to be build.
Naveen I am getting this error when i try to add the status column Starting ChromeDriver 2.40.565498 (ea082db3280dd6843ebfb08a625e3eb905c4f5ab) on port 3709 Only local connections are allowed. Jun 19, 2018 10:29:42 AM org.openqa.selenium.remote.ProtocolHandshake createSession INFO: Detected dialect: OSS Exception in thread "main" java.lang.Error: Unresolved compilation problem: SOLID_FOREGROUND cannot be resolved or is not a field at naveen.execl.utility.Xls_Reader.addColumn(Xls_Reader.java:358) at naveen.datadriven.test.ParameterizeTest.main(ParameterizeTest.java:29)
Hi Naveen , thank you so much for the video.I watched Part-1 video as well. Here am having one doubt, after entering the values in fields we need to Submit after that we should get some success/error message . Can you please help me how to do that , when taking values from multiple rows .
Thanks Naveen....if you can make a video on excel reader utility will be really helpful....because in one company i have been asked to read the data from excel and store it in Map .....so could you please make the excel reader video as well..thanks in advance
Hi Naveen, You are just amazing. You are my idol. God bless you, bro. Can you please tell me how to set Pass/Fail status on the behalf of the dynamic result.
Hi sir, If I want to fetch data from both sheet1 and sheet2 how I should write the code using xls reader... If I run the program, in single time it should fetch data from both sheet1 and sheet2.. (for ex: the page should get login and go to registration page and fill the details) Please reply for this sir
Naveen plzz help.....there is error in xls_reader.java class in 293,359 and 402 line due to which im not able to create another column(error in 359 in xls reader.java class).though I have added all jars whichever you added
Hi Naveen, Thanks for this video, Great work! Is there a way to update the excel sheet on network or sharepoint using the utility you provided? Please advice
Hi sir, I'm not getting any errors in the code. But my test is getting skipped. And I'm doing DDT for login screen for both positive and negative values. Please suggest me on this.
Hi Naveen...your Selenium lectures are not only informative but interesting also...I am getting few errors after copying XLS reader java file in eclipse...like CELL_TYPE_NUMERIC cannot be resolved or is not a field...CELL_TYPE_BLANK cannot be resolved or is not a field etc..Could you please help to resolve these issues..
It's due to the version of Poi library you have installed. You must be using latest version 4.0 or something. In latest version it is deprecated. you have two options either you change your Poi library version to 3.17 as per video or replace CELL_TYPE function to FillPatternType. Hint: Just copy paste the error on google and you will get lot of solution like the one I mentioned.
Anyone please help as For first time only I am able to read data from excel but for second time getting blank. It is happing for each scripts. Not able to read data from excel after 1st execution.
Naveen I am hitting LINK_FILE cannot be resolved or is not a field in Xls_Reader. Java.. Seems like poi 3.17 version is does not have hyperlink field. Can you help me out how do we resolve it
@Naveen AutomationLabs, Please put subtitle in your all videos. Actually i am hearing impaired and can't able hearing what you talked on this videos. So i can read with subtitle while you teach on selenium videos. Thanks.
I'm having trouble with the file for the following line 1. if (cell.getCellType().name().equals("STRING")) - error msg is "cannot invoke name() on the primitive type int" 2.else if (cell.getCellType().BLANK != null) - error is "BLANK cannot be resolved or is not a field" please help, please it is Very IMPORTANT please
In Xls_Reader java file XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE) style.setFillPattern(HSSFCellStyle.NO_FILL); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); The above three constatnt are not recognised what should i do. I havnt attached source code in e clipse to POI APIs.
I got 3 errors when I pasted Xls_Reader.java file. Line no.270(XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE) Error showing in LINK_FILE. REST TWO ERRORS ARE ASLO SAME TYPE. Line number 336 SOLID_FOREGROUND and line number 379 NO_FILL. Please help me out Naveen.
Hi Naveen thanks for the video Please do one video on this below scenario Go to yatra.com--one way trip Search flights We see flight names timings fare for many flights ... Retrieve all the entries to excel(write to excel) Please post for me please
Hello All, Sharing the latest Excel Util - Xls_Reader class used to perform read/write operations on Excel files. This util is having all the latest dependencies as per Apache POI api - 4.x.x version. You can get this util from my GIT Repo:
github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java
Thanks man , Really Great XLS Utility, Had used your Old One , that is good too . but this new one also has an method for Hyperlink !!
4 Years gone, but the quality still remains unaffected... Really awesome explanations in simple language... now I am ready for switching thank you @naveen
Excellent job Naveen. This is the best channel to learn automation in a simple & systematic way. Thanks a lot Naveen.
Naveen....you are of the best teachers I have ever came across.you can make a even 7th standard student expert in selenium and that's the kind of explanation u give.....thanks a lot sir for the bottom of my heart...
Naveen your videos are just amazing. Your way to explain each and every thing is just super. You have refined every term in a simple way. Thank you so much. With your videos, my interest to learn automation testing is boosting up.
Thanks for watching @pradeep
Such a great explanation. Keep up the good work Naveen. Thanks
Thanks Naveen for awesome explanation about data driven and parameterization :) keep posting
Hi Naveen, it's very useful and thanks for the wonderful sessions.
@2:26 Closing Excel file to keep away from corrupting.
@3:18 A code to add column in Excel file.
@3:54 A code to enter some data into a single cell.
@6:48 Running the code.
@10:24 Creating a class under package which is consisting Datadriven Test.
@10:54 A code to access Excel sheet.
@11:19 A code to add new Excel sheet and giving name to it
@11:55 Running the code.
@12:22 A code to check particular Excel sheet is present or not. If not, then add it.
@13:50 Running the code.
@15:00 A code to print the count of columns belonging to particular Excel sheet.
@16:12 Running the code.
@16:42 A code to print a row number based on particular cell value.
@18:38 Running the code.
Thanks for everything you do Naveen!
thanks for the very useful training videos
Your video is so interesting. Great job. Thanks for helping us.
Thanks for watching
Hi, great tutorial. But when I enter any value like Zip code(411001) in excel it will give me the return value in code as (411001.0). How we will solve this issue as I have number of value in excel which are in int format.
Please help me where the code need to add or logic need to be build.
Well, Explained! Thanks a lot!!
It's very helpful and thankq naveen.
Naveen I am getting this error when i try to add the status column
Starting ChromeDriver 2.40.565498 (ea082db3280dd6843ebfb08a625e3eb905c4f5ab) on port 3709
Only local connections are allowed.
Jun 19, 2018 10:29:42 AM org.openqa.selenium.remote.ProtocolHandshake createSession
INFO: Detected dialect: OSS
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
SOLID_FOREGROUND cannot be resolved or is not a field
at naveen.execl.utility.Xls_Reader.addColumn(Xls_Reader.java:358)
at naveen.datadriven.test.ParameterizeTest.main(ParameterizeTest.java:29)
Hi Naveen , thank you so much for the video.I watched Part-1 video as well. Here am having one doubt, after entering the values in fields we need to Submit after that we should get some success/error message . Can you please help me how to do that , when taking values from multiple rows .
Thanks Naveen....if you can make a video on excel reader utility will be really helpful....because in one company i have been asked to read the data from excel and store it in Map .....so could you please make the excel reader video as well..thanks in advance
Hi Naveen, You are just amazing. You are my idol. God bless you, bro. Can you please tell me how to set Pass/Fail status on the behalf of the dynamic result.
Hi sir,
If I want to fetch data from both sheet1 and sheet2 how I should write the code using xls reader... If I run the program, in single time it should fetch data from both sheet1 and sheet2.. (for ex: the page should get login and go to registration page and fill the details) Please reply for this sir
Naveen plzz help.....there is error in xls_reader.java class in 293,359 and 402 line due to which im not able to create another column(error in 359 in xls reader.java class).though I have added all jars whichever you added
Nice tutorial. Thank you.
Hi Naveen, Thanks for this video, Great work! Is there a way to update the excel sheet on network or sharepoint using the utility you provided? Please advice
Can we use ur xls reader to compare two Excel and write to a new excel as a result? By the way, A very good tutorial. Thank you so much!
I'm not able to fetch the data and see in console, any other utility for reading excel sheet
The code is not writing to excel ..any help? I am able to read the data from excel but the is not written to the excel. Tried refreshing .. thanks
Hi sir,
I'm not getting any errors in the code. But my test is getting skipped. And I'm doing DDT for login screen for both positive and negative values. Please suggest me on this.
Hi,I have added Excel utilities file in my project but it is giving errors for some lines, like getcelldata.name().. Need help
hi,I have added Excel utilities file in my project but it is giving error.Please Help.
Hi Naveen...your Selenium lectures are not only informative but interesting also...I am getting few errors after copying XLS reader java file in eclipse...like CELL_TYPE_NUMERIC cannot be resolved or is not a field...CELL_TYPE_BLANK cannot be resolved or is not a field etc..Could you please help to resolve these issues..
It's due to the version of Poi library you have installed. You must be using latest version 4.0 or something. In latest version it is deprecated. you have two options either you change your Poi library version to 3.17 as per video or replace CELL_TYPE function to FillPatternType. Hint: Just copy paste the error on google and you will get lot of solution like the one I mentioned.
Anyone please help as For first time only I am able to read data from excel but for second time getting blank. It is happing for each scripts. Not able to read data from excel after 1st execution.
Naveen I am hitting LINK_FILE cannot be resolved or is not a field in Xls_Reader. Java.. Seems like poi 3.17 version is does not have hyperlink field. Can you help me out how do we resolve it
Expecting your reply
@Naveen AutomationLabs, Please put subtitle in your all videos. Actually i am hearing impaired and can't able hearing what you talked on this videos. So i can read with subtitle while you teach on selenium videos. Thanks.
sir,how to make the status both pass and fail in excel
I'm having trouble with the file for the following line
1. if (cell.getCellType().name().equals("STRING")) - error msg is "cannot invoke name() on the primitive type int"
2.else if (cell.getCellType().BLANK != null) - error is "BLANK cannot be resolved or is not a field"
please help, please it is Very IMPORTANT
please
Thank you Naveen
hi Naveen i cant not get your Excel sheet
hi naveen
in real time how can we use utility class
In Xls_Reader java file
XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE)
style.setFillPattern(HSSFCellStyle.NO_FILL);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
The above three constatnt are not recognised what should i do.
I havnt attached source code in e clipse to POI APIs.
Im facing the same issue , if you find the solution to the same , would you please let me know.
I've same problem and no response from "coach" :-)
Andrey Sytnik downgrade your apache POI version in POM.xml dependency to the one hes using.. worked for me
Thanks, Avik! I configured my project to Maven and used version POI 3.15. Now everything works properly!
Hi if we can download and POI 3.16 version jar files it will work
archive.apache.org/dist/poi/release/bin/
I got 3 errors when I pasted Xls_Reader.java file. Line no.270(XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE)
Error showing in LINK_FILE. REST TWO ERRORS ARE ASLO SAME TYPE. Line number 336 SOLID_FOREGROUND and line number 379 NO_FILL.
Please help me out Naveen.
Please help me to resolve the error.
Hi Naveen thanks for the video
Please do one video on this below scenario
Go to yatra.com--one way trip
Search flights
We see flight names timings fare for many flights ...
Retrieve all the entries to excel(write to excel)
Please post for me please
thanks for sharing
Sir iwant notes of interview points
Nice tutorial. Thank you.
how do you merge the excel files?