02 Getting Data from a specific Cell of an Excel file using Java - with Row Number & Column Number

Well we have seen so far how to read data from excel using Apache POI library, now in this video tutorial we will see how you can read data from an excel by providing row number and column number as a function.

So in this video I gave detailed explanation as how to we can dynamically get data from a specific cell of an excel when we are aware of column number and row number.

In case you have landed on this video directly, I recommend you to first go through all the Video tutorials related to Apache POI for reading data from excel files.

01) Reading Excel using Apache POI with java language

02) Getting data from excel using row number and column number

03) Getting data from excel using row number and column name

04) Comparing two excel files and understanding the difference of content between 2 files

05) Quick Walk through on Reusable Excel Library

[onurcang]

Thanks you so much sir Realy helped me pls keep going java series :)

[sksinghmotihari]

Hi Sir, Could you please share How to Compare 2 Excel Files with some empty cell in Java

[archanamuthukrishnan]

Hello Sir
I need to search for particular value in excel and copy its value . Currently i am getting all values and comparing each value if it is true getting its value..i am having many records hence it takes so much time to complete the script...is there any optimized way to do the same

[vaibhavsuryawanshi]

It is useful video and easy to understand.
But sir i am looking for a solution for a configuration which will provide data to test cases using Dataprovider method. And Dataprovider will take data from excel sheet. Condition- different test case need data from different excel workbook and different sheet and having data columns like numeric, string, date. All all Dataprovider will be one class.
All appache poi methods will be in single class just like in video(Excel.java) this methods will be comon for all dataprovider methods. That dataprovider will use this methods accordingly their need to read data from user expected workbook and sheet as per test case requirements.