Part 7 -Read Excel with 1 line of Code - Drive your tests from Excel - Test Data Supplier & Zerocell

Hi All,

In this video we will see how we can read excel sheet with just one line of code using Zero cell and Test Data Supplier

[avishekbehera]

Wow, this is excellent.
Reading Excel files has been a pain for various reasons.
Handling exceptions, File IO operations, If Excel is open then it throws error...many more
This really simplifies the whole coding level.
Much better control on filters.
Amuthan, big shout out for requesting this feature to the developer, I had a look on your improvement ticket, and good to see them responding to it fast and very well.
So many kinds of stuff, this is indeed a great contribution as a software engineer like you. Keep it up, thank you.

[Millions-hwcs]

Briefly explained
Thanks for this video

Can you make video on how to read data from Google spreadsheet in Java - Selenium?

[gopinath]

Hi Amuthan from where you getting this all new library it will be useful for some people to learn all new things

[abhiku]

Great video . Could you please upload or share a video how to automate an putty/SSh to run any set of commands via Java or python

[mr_possible]

thanks for the video sir, I have one question. How to achieve Yes/No condition with this approach. Suppose I want to use only those rows as testdata which have a column named as 'Execute' and its value is YES, then how can we do this ?

[webtestingui]

@Amuthan, can you please provide the git repo of this project

[gokulkrishnan]

Hi bro pls tell what is to string in pojo

[sunithagudivada]

I am getting " Unable to access resource specied" even though the excel is in resource folder. I tried giving full path too. Yet it failed. Can somebody please help

[mohamedakram]

Also getting this issue -> java.lang.RuntimeException: org.joor.ReflectException: when i set the version of test-data-supplier version to 1.9.7 from 2.3.0

[mohamedakram]

I was using an xlsx sheet with the name of the first column as Firstname but have been getting this issue -> java.lang.RuntimeException: Column firstname not found. No matter how hard i try to debug this issue, it has been persistent regardless.I even cross-verified for any issues regarding deprecated dependencies etc but none were there