Awesome

XLS Test

Excel testing library

Be sure that your code generates correct Excel!

How to use

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"));
  }
}

How to start

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'

How to contribute

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!

Thanks

Many thanks to these incredible tools that help us to create open-source software:

License

xls-test is open-source project and distributed under MIT license