How to read excel file in Selenium Webdriver using JExcel API

[@nagagsalka5371]

Thank you so much Mukesh, you video really helped me Keep up with your video posting for people like us, GOD bless you ......................

[@Mukeshotwani]

Nagag Salka thnx :)

[@bonker27125]

wow . i am new to selenium and this made my job easy .. amazing and thnkyou very much Mukesh

[@Mukeshotwani]

bonker27125 Thanx keep visiting and watching

[@parshi82]

over all a very good one... up to point and informative ..

[@jyothipp6486]

All your videos are very good.Simple, very clear and easy to start with. Thank you very much.

[@Mukeshotwani]

Thanks Jyothi.

[@nazreenasraf8850]

Easy to understand...Thnz Mukesh

[@Mukeshotwani]

Hey Asraf thanks :)

[@MyselfSankar]

Simply Awesome Mukesh... Like to see all your videos...

[@Mukeshotwani]

thnx

[@kevin050607]

simple and superb, thank you!

[@Mukeshotwani]

Welcome Thanga :) Keep visiting.

[@saikishorebolla7858]

Thanks Mukesh, it is quite easy for understanding and explaining the subject in simple way.

[@nagagsalka5371]

Cool ...............very very helpful

[@vasaviselenium8748]

Clear explanation.Thank you for sharing videos.

[@Mukeshotwani]

Vasavi most welcome

[@supriyalunge8213]

Thank u Mukesh... It's very helpful...

[@vinayakpatil8832]

Thanks Mukesh...your video really helped me and cleared my doubts...

[@Mukeshotwani]

Hi VInayak, I am glad it helped. Kindly check Apache POI which is used now in market kzbin.info/www/bejne/qZOllZ1qr66Ap7s

[@amandeepsingh4840]

Nice tutorial, easy to understand... thanks.

[@Mukeshotwani]

+Amandeep Singh Thanks Amandeep

[@TheMANISHMANI]

I am very thankful to you .

[@Mukeshotwani]

+MANISH MANI Thanks manish

[@nikilraj5298]

Very cool ..Nice one..

[@Mukeshotwani]

sai ram Thanks Sai

[@tanushrimukherjee2762]

Awesome one.. Since long just willing to watch and learn and finally started.. Interesting as well as too easy to understand.

[@Mukeshotwani]

+tanushri mukherjee thanks Tanu keep learning. Really appreciate your dedication. Let me know if any help from my side. 😊

[@Mukeshotwani]

+tanushri mukherjee watch Apache POI instead of JExcel

[@seenukaniappan8882]

Very Good Presentation👌

[@Mukeshotwani]

+Seenu Kaniappan Thanks Seenu

[@pushkarbajpai8989]

realyy very helpful video.

[@Mukeshotwani]

+Pushkar Bajpai Thanks Pushkar

[@asadyousuf5131]

Very Well Explained :)

[@ramalakshmi5640]

very helpful and easy understandable tq for sharing

[@Mukeshotwani]

Your most welcome.keep learing.

[@ruchinkhare2990]

Thanks to You :) and I love to watch your video as it is having very easy and good presentation.

[@Mukeshotwani]

+ruchin khare thanks Ruchin I will suggest try with apache poi which is latest.. Jexcel has some limitations

[@jayavyas1]

thanks so much with sharing details.

[@Mukeshotwani]

+jayshri vyas Hey jayshri thanks let me know if any help from my side.

[@batchuabhilash6642]

It was good and I m new learner

[@Mukeshotwani]

Batchuabhilash Kumar Thanks :)

[@AwesomeStuff2424]

*Thanks a lot Sir for the time and dedication you spent on these videos and helping people like us, God bless* :)

[@Mukeshotwani]

Thank you mate 🙏🙏 Keep learning

[@munna4078]

its easy learning

[@Mukeshotwani]

Thanks Munna

[@raghuram2258]

Great video

[@Mukeshotwani]

thnx Raghu

[@Dishan1011]

can you make similar video for using C#? I need to do parameterization using selenium webdrive in C#

[@Mukeshotwani]

Yamini Shah Hi Yamini, I have covered most of the Selenium topics using Java only so not sure about C#. I will check from my end will update you. Have a nice day

[@girinivasmanivasagam3965]

Thanks you Mukesh

[@Mukeshotwani]

+Giri Nivas most welcome Giri

[@kalyanchakravarthy6098]

Can you share the youtube link of how to write excel file Selenium Web driver using Jexcel API

[@bananidas7984]

Hi Mukesh, I was going through your videos for 'Cross Browser Testing' and 'Selenium Integration with Jenkins' . Both are very informative and good. Had one question. Do you have any videos for the use of '@dataprovider anotation' of Testng. Thank you,

[@Mukeshotwani]

Banani Das yes I am creating the same will upload soon.

[@codeofethics1]

thank you so much mukesh

[@Mukeshotwani]

+Fuad Hasan Your welcome Faud. Keep visiting.

[@codeofethics1]

+Mukesh otwani can you please upload a tutorial for uploading images/files using selenium webdriver?

[@Mukeshotwani]

Hi Fuad you can upload using AutoIT I have video for the same kindly check

[@codeofethics1]

+Mukesh otwani ok thank you let me check

[@Mukeshotwani]

Ok

[@himabindhureddy4645]

Hi Mukesh I am new to selenium and i have basic knowledge on core java too. Help me what are all the topics i have to cover to getting job. Thanks in Advance

[@Mukeshotwani]

+Himabindhu Reddy please share your email I will send you.

[@girinivasmanivasagam3965]

Thank You :)

[@Mithunkumar-kq3vt]

How to read heterogeneous data from excel sheet.

[@vinothbabu128]

super

[@Mukeshotwani]

thnx

[@parvesahammed3353]

can you also show the mac too pls tnx

[@naincypriya2281]

hi I want to know how to write in excel sheet using jxl.Please reply as soon as possible

[@Mukeshotwani]

Hi Priya, you can use POI which is much easier then JXL learn-automation.com/read-and-write-excel-files-in-selenium/

[@waheedahmed6524]

Can you show multiple login Username Password will be read for web page long from excel sheet..because we will have to insert them in findelements correct? Aslo do you have video around this?

[@Mukeshotwani]

Hey Ahmed, yes I have covered the same in below video kzbin.info/www/bejne/lWi7e5ikiduFaZY

[@rajiraji-ux2zh]

Hi Mukesh when I'm executing my test using testng with data driven framework using jxl im getting error as [Utils] [Error] [Error] org.testng.TestngException: Cannot inject @Test annotated method how can I resolve this

[@Mukeshotwani]

Hi Raji, I have explained the same using APACHE POI learn-automation.com/data-driven-framework-in-selenium-webdriver/

[@rizwansharieff2607]

hi mukesh how to read data from open office

[@ilzat-rozaji]

Hi Dimash, I am having Access Denied . Please advise

[@Mukeshotwani]

Hi Mate, Please check whether you have access permission for that folder where excel is located? If not then please keep excel in location where you have action.

[@divyachouhan1957]

Hi mukesh, When i try to run this program,i am getting below exception in console: File found Exception in thread "main" jxl.read.biff.BiffException: Unable to recognize OLE stream at jxl.read.biff.CompoundFile.(CompoundFile.java:116) at jxl.read.biff.File.(File.java:127) at jxl.Workbook.getWorkbook(Workbook.java:221) at jxl.Workbook.getWorkbook(Workbook.java:198) at ExcelReadWrite.ReadExcel.main(ReadExcel.java:18) Please suggest what could have gone wrong

[@Mukeshotwani]

Hi Divya, Please use apache POI for excel sheet learn-automation.com/read-and-write-excel-files-in-selenium/ Note- JExcel is older now

[@divyachouhan1957]

thank you

[@moshiurrahman895]

after write this code out put is like this :Excel located Exception in thread "main" java.io.FileNotFoundException: C:\Users\User\TestData1.xls (The system cannot find the file specified) at java.io.FileInputStream.open0(Native Method) at java.io.FileInputStream.open(Unknown Source) at java.io.FileInputStream.(Unknown Source) at jxl.Workbook.getWorkbook(Workbook.java:213) at jxl.Workbook.getWorkbook(Workbook.java:198) at lib.ReadExcell.main(ReadExcell.java:14) whats problem ?i have writen: File src=new File("C:/Users/User/TestData1.xls");

[@Mukeshotwani]

Hi Rahman please use apache poi for reading excel. JExcel is outdated now