Excel testing library
Be sure that your code generates correct Excel!
import com.codeborne.xlstest.XLS;
import static com.codeborne.xlstest.XLS.*;
import static org.hamcrest.MatcherAssert.assertThat;
public class ExcelContainsTextTest {
@Test
public void canAssertThatXlsContainsText() {
XLS spreadsheet = new XLS(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.7.2</version>
</dependency>
If you use Gradle, add the following dependency to build.gradle:
testCompile 'com.codeborne:xls-test:1.7.2'
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