How to read excel file in cucumber project?

Question

I am creating testing automation framework using java but i am not able to read excel file in cucumber.

is there any way to use @DataProvider functionality og testNG?

I do not want to use datatable of feature file.

Solution

If you use CucumberJVM, I don't think you can make use of TestNG Data Providers without major hacks. Or at least this is not a "cucumber way" of doing things. Data Table is a Cucumber equivalent of TestNG Data Provider:

https://cucumber.io/docs/reference#data-tables

This is how you parametrise tests in Cucumber. I'm not saying the solution you are looking for can't be implemented, I'm saying you are most likely looking for a wrong thing. CucumberJVM makes use of DataProviders internally, to handle features this way:

https://github.com/cucumber/cucumber-jvm/blob/master/testng/src/main/java/cucumber/api/testng/AbstractTestNGCucumberTests.java