03 Dynamically Get Data from a Specific Cell of an Excel using Java - with Row Number & Column Name

Well we have seen so far how to read data from excel using Apache POI library, but ideally in the world of test automation, we want the function to get data from excel should be more dynamic, like if we give a column name and row number we should be able to get the data from that cell.

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

[luiskayrumetperezbuigas]

i really liked this video, it gave you a solution to future changes in a excel file

[Coders_World]

I am getting one error while reading the empty cells. it is reading some empty cells and skipping some empty cells.

[pratibhasharma]

getting Null Pointer exception while I'm trying to print column number.