Read Data From Excel Using Column Number

[@RituGurnani_India]

Too good. I recommend everyone should watch this.

[@KrishnaSakinala]

Thank you *R G* ... :)

[@MrSainath19]

Superb.. thanks a lot for sharing your knowledge..!!

[@softwareteam4780]

Hi Krishna, Great Video, Can you please show same with for loop for rows & columns so that can be used for any set of data in excel? Thank you.

[@151181harpal]

Brilliant. Thanks a lot for sharing it. I was exactly looking for something like this where we handle different types of data in the excel. BIG thanks

[@151181harpal]

Sure will keep visiting your channel and i am already subscribed. lots of information on your channel

[@priyabratasahoo9990]

I say thank you sir..its really helpful and keep it up your good job

[@KrishnaSakinala]

Thanks for the feedback... :) Please subscribe to the channel and keep visiting Like the video and share the video.

[@RituGurnani_India]

Krishna plz keep putting real life sceniores after explanation of any concept. I suggest ur videos to whoever wants to actually learn selenium from basics to advance

[@KrishnaSakinala]

Sure *R G* ... :)

[@ulradeja5380]

exactly what I'm looking for

[@pramyahs2612]

Hi Krishna, Thanks for this video, can you please make a video to read data from excel and store in arraylist. thanks for the help!!

[@Cherupakstmt]

Great Video Thanks

[@chaithrag9545]

Can you explain these code to retreive in JSP page aswell?

[@maheshbaburampatruni]

sir i want print only numaric column how to write a code pls tell me sir

[@theoraj1665]

Hi Sir, If I filter data in excel sheet I will get the row count, how can I get it in Java program. And to do vlookup of two Excel sheet by program Plz help.

[@vineetnt]

Thanks a ton for this video, you resolved one of my issue... :-)

[@KrishnaSakinala]

That's great man... Thanks for the feedback *Vineet Sharma* ... :) Please subscribe to the channel and keep visiting...

[@AshishKumar-mw1hv]

Sir Same code while writing showing error as - The method must return a result of type String.plz help

[@punitb9853]

How to get the cell when the cells are merged ? for example i have a test to verify the excel headers which is names and Product Details and then it has sub coloumns as itemname, price and size? how do we test this?

[@KrishnaSakinala]

I never tried *Punit B* . Let you know If I get any info. on this.

[@keshavramaiah1601]

For me XSSFWorkbook line is throwing classnotfoundexception what may be the problem

[@KrishnaSakinala]

Please check all the related jar files added or not?

[@Bujji28243]

y we need to use FORMALA??? IF BLANK Cell then Boolean type true r false then what is use when entering data into application ???? I want skip blank space ,then how can handle Rama krishna

[@arjunms1736]

Instead of getting one value at a time...can we fetch all the cell values using for loop...pls explain

[@KrishnaSakinala]

Yes you can do by using for loop.

[@arjunms1736]

Hi sir...i am not able to implement using forloop...can you pls explain it.

[@rpnaidu9724]

😍

[@Bujji28243]

awesome

[@KrishnaSakinala]

Thanks for the feedback *Nagulmeera Shaiks* Please subscribe to the channel and keep visiting... :)

[@Bujji28243]

I already subscripe and Share with my frinds also

[@Bujji28243]

I faced oNe question in interview from on of MNC company that is :: how to validate duplicate data in the calums while register the application already register date came then application given error massage like " The user alreay register" so then how can handel in duplicate date in excel and how you know wether this data is duplicate data....????

[@Bujji28243]

+Nagulmeera Shaiks please answer this question

[@KrishnaSakinala]

Frankly speaking I did not understand the question. But we use test data outside to feed to the application properly. Why to check duplicate data in Excel. So, we need to maintain proper test data not to get these type of issues. So, we need to maintain unique test data to test the application. I am going to publish the videos soon on this.

[@parasjoshi5509]

There is no Enum Method in Eclipse ... Better show a code for eclipse

[@KrishnaSakinala]

Hi *Paras Joshi* , I am not clear what is your question. Can you be more clear?