I am new to c#, i am writing a test project to test one application. The data for application is given in excel. What i want is, i have to write a test method for each sheet in excel. But the sheets in excel is not fixed, it may be changed in future.
I have to generate test method for each sheet dynamically using one test method.
Please provide any solution for this.