@LetCode with Koushik... Wow, Really Wow bro... Romba easy ya step by step explain panniteenga... I have done the handson as well immediately now, and able to print the data from excel... Felt wonderful when i saw the data in Console.. You are Great bro...!!!
Hi bro..at last 5 months i regularly watched your videos realy helpful no words to say..have a doubt in one place .in this video u displayed both username and password with getstringvalue method..i want to show as separately for username and password..where i have to change and how..have to store in a variable for both username and password..pls reply..am waiting to that
12:53 I have done the same in my Eclipse IDE and successfully, read the cell value and printed it in the console. However, in the console, I got the following error message "ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console..."
Hi bro Your teaching is amazing..... I have the query Is it possible to read the data from Excel and convert as JSON then pass the same data to our specific function?
Thanks for replying... I have done the Excel to json file but while converting json no need to create json file so we directly pass the data from Excel to specific function through JSON. Is it possible?
ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console... Why this issue shows
Hi ..using Apache poi geting error as Noclassdeffounderror exception even after installing all jar and tried even through maven..what is the issue ..can you assist me on this...
Thank you ☺️@@letcode in POM DDT is it possible to write a string resulting from a method(page class) into an existing excel Sheet I never saw any video or content related to it Could you please help me with this
Sir am facing error status logger Log4j could not find logging implemenation in line 10... I wrote the code u mentioned in this video sir... but getting error like this.
Hi Bro, Im getting the following error when i use latest Apache POI however it is working fine when i use the same version as yours.. what has to be changed when we use latest one ? please advise
Dependencies are not downloaded properly. Force update maven project. To force update a Maven project in Eclipse, you can follow these steps: 1. Right-click on your Maven project in the Project Explorer. 2. Navigate to "Maven" in the context menu. 3. Select "Update Project." This will update your Maven project, fetching the latest dependencies and updating the project configuration.
17:08 Closing the workbook is he new learning...! such a uniqueness from other channels.
Cool 😎
Well explained. Understood and I can remember this all time now.
Awesome
Bro vera level teaching will share these testng videos with my friends.
Thanks bro 😊
@LetCode with Koushik... Wow, Really Wow bro... Romba easy ya step by step explain panniteenga... I have done the handson as well immediately now, and able to print the data from excel... Felt wonderful when i saw the data in Console.. You are Great bro...!!!
Super bro 🤠
Clear explanation, congrats
Hi bro..at last 5 months i regularly watched your videos realy helpful no words to say..have a doubt in one place .in this video u displayed both username and password with getstringvalue method..i want to show as separately for username and password..where i have to change and how..have to store in a variable for both username and password..pls reply..am waiting to that
Create 2 variables and while getting the value store it.
@@letcode OK bro..let try I share with you
Hi bro..got it thanks lot...run successful
Thank u so much for teaching
Nandri... Nandri.. Nandri...
Welcome 🤗
It very useful sir
Great 👍
Thank you bro keep rocking
Thanks bro 😄
Anna maven main la main method kuduringa run panna mudiyuma?
Pannalam bro, all possible 😀
Enda video ku previous video etha pakurathu maven install paniten
Follow this playlist bro
ua-cam.com/play/PL699Xf-_ilW6vI9FHmePi1TvKyzYATgXi.html
12:53 I have done the same in my Eclipse IDE and successfully, read the cell value and printed it in the console. However, in the console, I got the following error message "ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console..."
That's a warning, you can ignore that or you can add the log4j dependencies.
Data driven framework edhuvum same ah
Yes
Ok thanks bro real time edhu maximum use pannuvanga
Hi bro
Your teaching is amazing.....
I have the query
Is it possible to read the data from Excel and convert as JSON then pass the same data to our specific function?
Yes possible.
Thanks for replying...
I have done the Excel to json file but while converting json no need to create json file so we directly pass the data from Excel to specific function through JSON.
Is it possible?
Without creating a json file we cannot use the data directly.
To store and retrieve we need some sort of file.
@@letcode thanks bro thankyou very much for your costly reply
ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...
Why this issue shows
It's a dependency issue for loggers.
Hi, the Excel sheet folder is not available in eclipse. I have refreshed multiple times
Is the folder within the project folder?
Hi bro , Eclipse shortcuts ku video iruka?
ua-cam.com/video/arOraX0ubTk/v-deo.html
Hi ..using Apache poi geting error as Noclassdeffounderror exception even after installing all jar and tried even through maven..what is the issue ..can you assist me on this...
That should be a problem only with jar files.
Add both the dependencies.
Poi and poi ooxml
Faced same problem try with poi-ooxml only 3.9 version dependency... its working for me...
Nice
🙋
Bro enakku correct ah print Achu , but for loop use pannum pothu "illegal state exception" cannot get string value from NUMERIC cell ...varuthu
Next video paarunga, idhuku solution irukum
K bro...
Bro base class konjam detail ah sola mudiuma.. method reusable doubts iruku
Reusable methods ku seperate videos potu erukan bro, adhu check pannunga.
Ok bro thanks
10:01 what is the shortcut for return bro
ua-cam.com/video/arOraX0ubTk/v-deo.htmlsi=096TuomimFKJFKDj
Thanks bro.. 👍🏽
Bro is it possible to write into Excel using data provider?
Not using a data provider, but using Apache poi you can achieve that.
Thank you ☺️@@letcode in POM DDT is it possible to write a string resulting from a method(page class) into an existing excel Sheet I never saw any video or content related to it
Could you please help me with this
Ok sure.
@@letcode Bro do you have any sample codes for it or can you make a video on it please
Error parsing lifecycle processing instructions
Issue fixed ah ?
Video sequence ah paaru bro,
Playlist follow panna podhum
Selenium testng kuduthjngala edhuku modha video annupunga
Playlist eh follow Pannu bro.
how to use apache poi and poi ooxml dependency in intelij
Same if it's maven project.
You have to add dependencies in pom.xml
Bro customized excel report create Panna mudiyama selenium la
Pannalam bro, with Apache poi.
Testng listener vechi pannalam
Bro can u pls provide any sample cucumber framework with test cases for my interview preparation... Can u share GitHub link if u hav?
Cucumber + Selenium Java: ua-cam.com/play/PL699Xf-_ilW6oK3_otMtu7BPqiy0VlkE-.html
Bro excel sheet eclipse la open aagamatuku
Ms Excel system la install iruka?
Error could not find or load main class utils.readexcel varudhu bro solution pls
Sir am facing error status logger Log4j could not find logging implemenation in line 10... I wrote the code u mentioned in this video sir... but getting error like this.
Might be dependices error, kindly force update maven project.
@@letcode sir I tried force updating but the same error exist...
Sir I tried poi-ooxml only 3.9 version dependency... now its working... thank you sir...
@@avengersendgame8617 ok super
@@letcode sir the code is working but am eager to know how it's working could you please clarify it sir..
i have error in logj4j how to resolve to error
What is the error message?
14:41 I got a error as "Cannot get a string value from a numeric cell".
I have covered that in the next video, pls watch that
Yaravydhu number kudunga dout ketu clarify pannikiren please
You can ask here your doubt
discord.gg/EdbBuqNq
I tried to read date from excel but it return as null
Delete the row from Excel and create the data again and try reading
Getting error row cannot be resolved !
Row correct ah declare agala bro.
@@letcode Ty bro , can we feed the excel input into an web application ?
Hi bro,
I followed the same code but i'm getting null pointer exception for the stringCell value. Could you please advise
Is the cell has string value?
If so delete the entire row and then add the value and execute.
Or might be problem with loop as well
@@letcode now working fine bro after deleting and given values again !😊
Hi Bro, Im getting the following error when i use latest Apache POI however it is working fine when i use the same version as yours.. what has to be changed when we use latest one ? please advise
Pls use the same version as i used. The latest version might have some changes.
Source code is not working
Why ?
Bro discard la msg Panirken please reply
Dependencies kila error kamikudhu
Pom.xxl click panna kamikudhu edhuku munadi yenda video pakanum
refers agamattathu Sir
Yedhu refer agala?
Im getting Class not found Exception .. pls tell me how to solve
Dependencies are not downloaded properly.
Force update maven project.
To force update a Maven project in Eclipse, you can follow these steps:
1. Right-click on your Maven project in the Project Explorer.
2. Navigate to "Maven" in the context menu.
3. Select "Update Project."
This will update your Maven project, fetching the latest dependencies and updating the project configuration.