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 https://www.youtube.com/watch?v=gyOinrnIVGs&list=PLsCNyqG0Gn3A9W4NzNMYtKYJ51_ET8hRX&index=1&pp=gAQBiAQB 02) Getting data from excel using row number and column number https://www.youtube.com/watch?v=C9kFahE6Lnw&list=PLsCNyqG0Gn3A9W4NzNMYtKYJ51_ET8hRX&index=2&pp=gAQBiAQB 03) Getting data from excel using row number and column name https://www.youtube.com/watch?v=g7Lgafg4RGQ&list=PLsCNyqG0Gn3A9W4NzNMYtKYJ51_ET8hRX&index=3&pp=gAQBiAQB 04) Comparing two excel files and understanding the difference of content between 2 files https://www.youtube.com/watch?v=XFab0OjJ_DY&list=PLsCNyqG0Gn3A9W4NzNMYtKYJ51_ET8hRX&index=5&pp=gAQBiAQB 05) Quick Walk through on Reusable Excel Library https://www.youtube.com/watch?v=0ZfrrJ4M-3k&list=PLsCNyqG0Gn3A9W4NzNMYtKYJ51_ET8hRX&index=6&pp=gAQBiAQB