Excel testing library
Be sure that your code generates correct Excel!
importcom.codeborne.xlstest.XLS;
importstaticcom.codeborne.xlstest.XLS.*;
importstaticorg.hamcrest.MatcherAssert.assertThat;
publicclassExcelContainsTextTest {
@TestpublicvoidcanAssertThatXlsContainsText() {
XLSspreadsheet = newXLS(getClass().getClassLoader().getResource("statement.xls"));
assertThat(spreadsheet, containsText("Statement"));
}
}If you use Maven, add the following dependency to pom.xml:
<dependency>
<groupId>com.codeborne</groupId>
<artifactId>xls-test</artifactId>
<version>1.8.0</version>
</dependency>If you use Gradle, add the following dependency to build.gradle:
testCompile 'com.codeborne:xls-test:1.8.0'You are welcome to suggest your features and fixes!
Just fork the xls-test and create pull request. Any contribution is important!
Become part of open-source community!
Many thanks to these incredible tools that help us to create open-source software:
xls-test is open-source project and distributed under MIT license
