Read Data From Excel - Part 1 | Selenium தமிழ் | Selenium Tamil Tutorial

Hello Guys, In this video, we'll learn the how-to read data from excel using Apache POI
🤗 Learning from this video,
Read data from Excel
Dependency
1. Apache POI
2. Apache POI - OOXML
mvnrepository....
mvnrepository....
Pre- condition
1. Create an excel file with data
Steps to implement
1. Locate the file
2. Locate the workbook & Sheet
3. Read the data from the cell (Rows & Column)
4. Close the resource
Source code:
bit.ly/37JSF15​
Download my XPath extension
bit.ly/2T5EUCu​​
Join our Gitter community
bit.ly/3mWDqrC​​
Join our Facebook group
bit.ly/3mVvMxW​​
Behind the screen,
/ ortoni​​
Subscribe to LetCode
bit.ly/305DiMT​​
My playlist:
1. Protractor
bit.ly/3i2G3Vf​​
2. Selenium (Tamil)
bit.ly/3kMnyX1​​
and check more playlists and videos from the channel page.
#letcode​​ #selenium​​ #tamiltutorial
Join this channel to get access to perks:
bit.ly/3cSPCpm

[@rajkumarm25]

17:08 Closing the workbook is he new learning...! such a uniqueness from other channels.

[@letcode]

Cool 😎

[@AbinayaMurugan-e9t]

Well explained. Understood and I can remember this all time now.

[@letcode]

Awesome

[@joblesstamilan-273]

Bro vera level teaching will share these testng videos with my friends.

[@letcode]

Thanks bro 😊

[@malathiravi4890]

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

[@letcode]

Create 2 variables and while getting the value store it.

[@malathiravi4890]

@@letcode OK bro..let try I share with you

[@malathiravi4890]

Hi bro..got it thanks lot...run successful

[@karthickchandran7247]

@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...!!!

[@letcode]

Super bro 🤠

[@leemaajesus7223]

Clear explanation, congrats

[@karthickudhaya1878]

Anna maven main la main method kuduringa run panna mudiyuma?

[@letcode]

Pannalam bro, all possible 😀

[@tsiporche]

Nandri... Nandri.. Nandri...

[@letcode]

Welcome 🤗

[@jeyasankara4781]

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?

[@letcode]

Yes possible.

[@jeyasankara4781]

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?

[@letcode]

Without creating a json file we cannot use the data directly. To store and retrieve we need some sort of file.

[@jeyasankara4781]

@@letcode thanks bro thankyou very much for your costly reply

[@kalaimohan5421]

Thank u so much for teaching

[@mukeshvicky8404]

Data driven framework edhuvum same ah

[@letcode]

Yes

[@mukeshvicky8404]

Ok thanks bro real time edhu maximum use pannuvanga

[@rajkumarm25]

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..."

[@letcode]

That's a warning, you can ignore that or you can add the log4j dependencies.

[@harishv6727]

Hi bro , Eclipse shortcuts ku video iruka?

[@letcode]

kzbin.info/www/bejne/l6Oyo5SOZdqVis0

[@kbharathotk]

10:01 what is the shortcut for return bro

[@letcode]

kzbin.info/www/bejne/l6Oyo5SOZdqVis0si=096TuomimFKJFKDj

[@kbharathotk]

Thanks bro.. 👍🏽

[@sulthanarazia2014]

It very useful sir

[@letcode]

Great 👍

[@aravindk-iq4bc]

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

[@letcode]

It's a dependency issue for loggers.

[@sudhakumar7807]

Hi, the Excel sheet folder is not available in eclipse. I have refreshed multiple times

[@letcode]

Is the folder within the project folder?

[@vinodhinic1352]

Bro is it possible to write into Excel using data provider?

[@letcode]

Not using a data provider, but using Apache poi you can achieve that.

[@vinodhinic1352]

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

[@letcode]

Ok sure.

[@vinodhinic1352]

@@letcode Bro do you have any sample codes for it or can you make a video on it please

[@rajarathinam1965]

Enda video ku previous video etha pakurathu maven install paniten

[@letcode]

Follow this playlist bro kzbin.info/aero/PL699Xf-_ilW6vI9FHmePi1TvKyzYATgXi

[@rajarathinam1965]

Error could not find or load main class utils.readexcel varudhu bro solution pls

[@mariajeniffer2333]

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...

[@letcode]

That should be a problem only with jar files. Add both the dependencies. Poi and poi ooxml

[@avengersendgame8617]

Faced same problem try with poi-ooxml only 3.9 version dependency... its working for me...

[@vijaykumar-jp6pl]

Bro base class konjam detail ah sola mudiuma.. method reusable doubts iruku

[@letcode]

Reusable methods ku seperate videos potu erukan bro, adhu check pannunga.

[@vijaykumar-jp6pl]

Ok bro thanks

[@meeraswathi356]

Bro enakku correct ah print Achu , but for loop use pannum pothu "illegal state exception" cannot get string value from NUMERIC cell ...varuthu

[@letcode]

Next video paarunga, idhuku solution irukum

[@meeraswathi356]

K bro...

[@ramyasakthi1752]

Bro excel sheet eclipse la open aagamatuku

[@letcode]

Ms Excel system la install iruka?

[@suriyarajkumar8625]

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

[@letcode]

Pls use the same version as i used. The latest version might have some changes.

[@raptrdelta2095]

Bro customized excel report create Panna mudiyama selenium la

[@letcode]

Pannalam bro, with Apache poi. Testng listener vechi pannalam

[@praveenakathir3134]

i have error in logj4j how to resolve to error

[@letcode]

What is the error message?

[@ITZME11592]

Bro can u pls provide any sample cucumber framework with test cases for my interview preparation... Can u share GitHub link if u hav?

[@letcode]

Cucumber + Selenium Java: kzbin.info/aero/PL699Xf-_ilW6oK3_otMtu7BPqiy0VlkE-

[@ravichandran4452]

Thank you bro keep rocking

[@letcode]

Thanks bro 😄

[@avengersendgame8617]

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.

[@letcode]

Might be dependices error, kindly force update maven project.

[@avengersendgame8617]

@@letcode sir I tried force updating but the same error exist...

[@avengersendgame8617]

Sir I tried poi-ooxml only 3.9 version dependency... now its working... thank you sir...

[@letcode]

@@avengersendgame8617 ok super

[@avengersendgame8617]

@@letcode sir the code is working but am eager to know how it's working could you please clarify it sir..

[@manikutty007]

Nice

[@letcode]

🙋

[@thangapandi2906]

how to use apache poi and poi ooxml dependency in intelij

[@letcode]

Same if it's maven project. You have to add dependencies in pom.xml

[@rajarathinam1965]

Yaravydhu number kudunga dout ketu clarify pannikiren please

[@letcode]

You can ask here your doubt discord.gg/EdbBuqNq

[@rajarathinam1965]

Error parsing lifecycle processing instructions

[@letcode]

Issue fixed ah ? Video sequence ah paaru bro, Playlist follow panna podhum

[@rajarathinam1965]

Selenium testng kuduthjngala edhuku modha video annupunga

[@letcode]

Playlist eh follow Pannu bro.

[@logeshraja5489]

Hi bro, I followed the same code but i'm getting null pointer exception for the stringCell value. Could you please advise

[@letcode]

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

[@logeshraja5489]

@@letcode now working fine bro after deleting and given values again !😊

[@vishnuj7617]

14:41 I got a error as "Cannot get a string value from a numeric cell".

[@letcode]

I have covered that in the next video, pls watch that

[@balarj624]

I tried to read date from excel but it return as null

[@letcode]

Delete the row from Excel and create the data again and try reading

[@rajarathinam1965]

Bro discard la msg Panirken please reply

[@yaserarafat9058]

Getting error row cannot be resolved !

[@letcode]

Row correct ah declare agala bro.

[@yaserarafat9058]

@@letcode Ty bro , can we feed the excel input into an web application ?

[@ashikmohamed3465]

Source code is not working

[@letcode]

Why ?

[@rajarathinam1965]

Dependencies kila error kamikudhu

[@praveenakathir3134]

refers agamattathu Sir

[@letcode]

Yedhu refer agala?

[@rajarathinam1965]

Pom.xxl click panna kamikudhu edhuku munadi yenda video pakanum

[@SharmilaDevi-c7d]

Im getting Class not found Exception .. pls tell me how to solve

[@letcode]

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.