ExcelUtils | POI实现Excel文件读写操作工具类

i have a problem with TestNg, I am using java with Selenium. I have a message from TestNG:

testNG:org.testng.internal.reflect.MethodMatcherException: [public void utils.ExcelDataProvider.test1(java.lang.Object[][],org.testng.ITestContext) throws java.lang.InterruptedException] has no parameters defined but was found to be using a data provider (either explicitly specified or inherited from class level annotation). Data provider mismatch Method: test1([Parameter{index=0, type=[[Ljava.lang.Object;, declaredAnnotations=[]}, Parameter{index=1, type=org.testng.ITestContext, declaredAnnotations=[]}])

This is my @Test

I have been using the page object model framework with testing for running our automated tests and are using the page factory class for initializing the web elements of a page object. To initialize the web elements of a class I use the following statement in my page object constructor - objectname = PageFactory.initElements(driver, Page.class); Along with this piece of code, I also have another statement to initialize my driver inside the constructor. Something like driver = new firefoxdriver(); I know that this is not the correct way to do things but when I execute tests that have a call to this page my browser keeps opening again and again. However when I use this method - PageFactory.initElements(driver, this); this problem does not happen and my tests execute fine. Can someone explain how the function PageFactory.initElements(driver, Page.class); exactly works and why I am seeing what I see?

Here is my code

Updated the question and code again to reflect recent changes. Amit I tried your suggestion and I encountered an error. Trying to get openpyxl to read date from each excel sheet in a workbook by passing a testname in, but it keep failing with can't find testname fixture. Can you advise where I went wrong? Thanks.

I have an endpoint that should get an excel document using an ExcelUtility class that expects a Java.Util.List.

I am using Mongodb to fetch data, but Mongodb returns a Flux myList.

How can I "give" the ExcelUtility class the List myList to generate a Workbook class that I can return in the ResponseEntity?

So far I have this code:

I have two methods that use the same data provider. The Data provider reads an excel file to build the object to pass to the methods. However, when running the two methods in parallel, the data provider only passes back one variable for both methods.

I attempted to change the dataprovider variable names and object names but this did not work. I confirmed that the excel util function is working. Each if statement is called correctly in the data provider method, but it returns the wrong variable. How can I ensure that the data provider executes sequentially as to now mix up the variables?

Here is my Java class with testNG

I am trying to understand how reflection works, i cant able to figure out the problem. In the second for loop method.length is not fetching method from another program.

Following is the code:

I am trying to retrieve data from excel in my selenium test scripts. I have one excelData file where I have my code to read and set excel data and I have another class file where I'm fetching data from the excel. When I run my test script, it didn't return any data.

My Excel Code:

Below is the exception I'm getting while trying to read username and password of gmail from the Excel file stored on the specific location, tried with adding excel in the project as well. Please help in resolving this issue.

Exception

Well i have got an Class that reads a Excel-file as template.

• The class converts the Excel File to a Java Object
• Adds Information to the template
• rewrites the Template with the added Informations

i was reading some stuff about the single-responsibility-principle and decided that i need to refactor my class, because its doing more than one thing.

iam just not sure if iam doing to much here ?