TestSheet.java

import java.util.List;

import net.java.amateras.xlsbeans.annotation.HorizontalRecords;
import net.java.amateras.xlsbeans.annotation.Sheet;

@Sheet(name="test")        //Tab-Name
public class TestSheet {
    @HorizontalRecords(tableLabel="Aufführen", recordClass=TestData.class)    //Tabellentitel
    public List<TestData> testDataList;
}

TestData.java

import net.java.amateras.xlsbeans.annotation.Column;

public class TestData {
    @Column(columnName="No")
    public String no;

    @Column(columnName="TestCase")
    public String test_case;
}

GetXlsxData.java

@RunWith(Parameterized.class)
public class GetXlsxData{
	private TestData testData;        //Testparameter Entspricht einem Excel-Datensatz

	//Konstrukteur
	public GetXlsxData(TestData testData){
		this.testData = testData;
	}

	@Parameters
    //Testfallgenerierung aus Excel
	public static List<TestData[]> data() throws Exception {
		//Excel-Datei lesen
		TestSheet sheet = new XLSBeans().load(new FileInputStream("./testCase/selenium_testlist.xlsx"), TestSheet.class, WorkbookFinder.TYPE_XSSF);
		//Parametereinstellungen
		List<TestData[]> list = new ArrayList<TestData[]>();
		for (TestData testData : sheet.testDataList) {
			list.add(new TestData[] { testData });
		}
		return list;			//Zurück zum Konstruktor: Set(TestData testData)
	}
}

Recommended Posts