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.com/artifact/or...
mvnrepository.com/artifact/or...
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

Пікірлер: 104

  • @rajkumarm25
    @rajkumarm255 ай бұрын

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

  • @letcode

    @letcode

    5 ай бұрын

    Cool 😎

  • @leemaajesus7223
    @leemaajesus72232 жыл бұрын

    Clear explanation, congrats

  • @kalaimohan5421
    @kalaimohan54212 жыл бұрын

    Thank u so much for teaching

  • @user-sp4ge7zu7l
    @user-sp4ge7zu7l4 ай бұрын

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

  • @letcode

    @letcode

    4 ай бұрын

    Awesome

  • @joblesstamilan-273
    @joblesstamilan-2732 жыл бұрын

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

  • @letcode

    @letcode

    2 жыл бұрын

    Thanks bro 😊

  • @user-uw3up7qi2u
    @user-uw3up7qi2uАй бұрын

    Nandri... Nandri.. Nandri...

  • @letcode

    @letcode

    Ай бұрын

    Welcome 🤗

  • @karthickchandran7247
    @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

    @letcode

    Жыл бұрын

    Super bro 🤠

  • @ravichandran4452
    @ravichandran44522 жыл бұрын

    Thank you bro keep rocking

  • @letcode

    @letcode

    2 жыл бұрын

    Thanks bro 😄

  • @rajkumarm25
    @rajkumarm255 ай бұрын

    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

    @letcode

    5 ай бұрын

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

  • @sulthanarazia2014
    @sulthanarazia20145 ай бұрын

    It very useful sir

  • @letcode

    @letcode

    5 ай бұрын

    Great 👍

  • @malathiravi4890
    @malathiravi48902 ай бұрын

    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

    @letcode

    2 ай бұрын

    Create 2 variables and while getting the value store it.

  • @malathiravi4890

    @malathiravi4890

    2 ай бұрын

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

  • @malathiravi4890

    @malathiravi4890

    2 ай бұрын

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

  • @manikutty007
    @manikutty0076 ай бұрын

    Nice

  • @letcode

    @letcode

    6 ай бұрын

    🙋

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

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

  • @jeyasankara4781
    @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

    @letcode

    Жыл бұрын

    Yes possible.

  • @jeyasankara4781

    @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

    @letcode

    Жыл бұрын

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

  • @jeyasankara4781

    @jeyasankara4781

    Жыл бұрын

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

  • @user-ww9df7vn1k
    @user-ww9df7vn1k5 ай бұрын

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

  • @letcode

    @letcode

    5 ай бұрын

    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.

  • @aravindk-iq4bc
    @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

    @letcode

    Жыл бұрын

    It's a dependency issue for loggers.

  • @mariajeniffer2333
    @mariajeniffer23333 жыл бұрын

    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

    @letcode

    3 жыл бұрын

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

  • @avengersendgame8617

    @avengersendgame8617

    2 жыл бұрын

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

  • @sudhakumar7807
    @sudhakumar7807 Жыл бұрын

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

  • @letcode

    @letcode

    Жыл бұрын

    Is the folder within the project folder?

  • @praveenakathir3134
    @praveenakathir3134 Жыл бұрын

    i have error in logj4j how to resolve to error

  • @letcode

    @letcode

    Жыл бұрын

    What is the error message?

  • @karthickudhaya1878
    @karthickudhaya1878 Жыл бұрын

    Anna maven main la main method kuduringa run panna mudiyuma?

  • @letcode

    @letcode

    Жыл бұрын

    Pannalam bro, all possible 😀

  • @thangapandi2906
    @thangapandi29063 жыл бұрын

    how to use apache poi and poi ooxml dependency in intelij

  • @letcode

    @letcode

    3 жыл бұрын

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

  • @harishv6727
    @harishv67272 жыл бұрын

    Hi bro , Eclipse shortcuts ku video iruka?

  • @letcode

    @letcode

    2 жыл бұрын

    kzread.info/dash/bejne/k6aD1MORYNjIhM4.html

  • @meeraswathi356
    @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

    @letcode

    Жыл бұрын

    Next video paarunga, idhuku solution irukum

  • @meeraswathi356

    @meeraswathi356

    Жыл бұрын

    K bro...

  • @ramyasakthi1752
    @ramyasakthi1752 Жыл бұрын

    Bro excel sheet eclipse la open aagamatuku

  • @letcode

    @letcode

    Жыл бұрын

    Ms Excel system la install iruka?

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Error parsing lifecycle processing instructions

  • @letcode

    @letcode

    2 жыл бұрын

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

  • @rajarathinam1965

    @rajarathinam1965

    2 жыл бұрын

    Selenium testng kuduthjngala edhuku modha video annupunga

  • @letcode

    @letcode

    2 жыл бұрын

    Playlist eh follow Pannu bro.

  • @raptrdelta2095
    @raptrdelta20952 жыл бұрын

    Bro customized excel report create Panna mudiyama selenium la

  • @letcode

    @letcode

    2 жыл бұрын

    Pannalam bro, with Apache poi. Testng listener vechi pannalam

  • @logeshraja5489
    @logeshraja54893 жыл бұрын

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

  • @letcode

    @letcode

    3 жыл бұрын

    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

    @logeshraja5489

    3 жыл бұрын

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

  • @vishnuj7617
    @vishnuj7617 Жыл бұрын

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

  • @letcode

    @letcode

    Жыл бұрын

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

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Bro discard la msg Panirken please reply

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Enda video ku previous video etha pakurathu maven install paniten

  • @letcode

    @letcode

    2 жыл бұрын

    Follow this playlist bro kzread.info/head/PL699Xf-_ilW6vI9FHmePi1TvKyzYATgXi

  • @mukeshvicky8404
    @mukeshvicky8404 Жыл бұрын

    Data driven framework edhuvum same ah

  • @letcode

    @letcode

    Жыл бұрын

    Yes

  • @mukeshvicky8404

    @mukeshvicky8404

    Жыл бұрын

    Ok thanks bro real time edhu maximum use pannuvanga

  • @vijaykumar-jp6pl
    @vijaykumar-jp6pl2 жыл бұрын

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

  • @letcode

    @letcode

    2 жыл бұрын

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

  • @vijaykumar-jp6pl

    @vijaykumar-jp6pl

    2 жыл бұрын

    Ok bro thanks

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Yaravydhu number kudunga dout ketu clarify pannikiren please

  • @letcode

    @letcode

    2 жыл бұрын

    You can ask here your doubt discord.gg/EdbBuqNq

  • @ITZME11592
    @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

    @letcode

    Жыл бұрын

    Cucumber + Selenium Java: kzread.info/head/PL699Xf-_ilW6oK3_otMtu7BPqiy0VlkE-

  • @balarj624
    @balarj6242 жыл бұрын

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

  • @letcode

    @letcode

    2 жыл бұрын

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

  • @suriyarajkumar8625
    @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

    @letcode

    Жыл бұрын

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

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Dependencies kila error kamikudhu

  • @avengersendgame8617
    @avengersendgame86172 жыл бұрын

    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

    @letcode

    2 жыл бұрын

    Might be dependices error, kindly force update maven project.

  • @avengersendgame8617

    @avengersendgame8617

    2 жыл бұрын

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

  • @avengersendgame8617

    @avengersendgame8617

    2 жыл бұрын

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

  • @letcode

    @letcode

    2 жыл бұрын

    @@avengersendgame8617 ok super

  • @avengersendgame8617

    @avengersendgame8617

    2 жыл бұрын

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

  • @vinodhinic1352
    @vinodhinic1352 Жыл бұрын

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

  • @letcode

    @letcode

    Жыл бұрын

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

  • @vinodhinic1352

    @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

    @letcode

    Жыл бұрын

    Ok sure.

  • @vinodhinic1352

    @vinodhinic1352

    Жыл бұрын

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

  • @yaserarafat9058
    @yaserarafat90582 жыл бұрын

    Getting error row cannot be resolved !

  • @letcode

    @letcode

    2 жыл бұрын

    Row correct ah declare agala bro.

  • @yaserarafat9058

    @yaserarafat9058

    2 жыл бұрын

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

  • @rajarathinam1965
    @rajarathinam19652 жыл бұрын

    Pom.xxl click panna kamikudhu edhuku munadi yenda video pakanum

  • @praveenakathir3134
    @praveenakathir3134 Жыл бұрын

    refers agamattathu Sir

  • @letcode

    @letcode

    Жыл бұрын

    Yedhu refer agala?

  • @ashikmohamed3465
    @ashikmohamed34652 жыл бұрын

    Source code is not working

  • @letcode

    @letcode

    2 жыл бұрын

    Why ?

Келесі