I am working on a Java/TestNG UI automation framework and having some difficulties with test data management.
I use TestNG's DataProvider to pass data to the test method. I need to pass about 30 variables to test an end to end scenario and I have about 150 scenarios to test.
I saved each variable in a cell in an excel sheet and treat each row as a scenario. (150 rows, 30 cells in each row)
So I read the items in one row, create my Java object using those variables and pass that object to my test method to test one scenario.
Managing this data is a little difficult. Is there a preferred approach for this kind of problem?