Jxls-2 source

Contributing

1. Create an issue.
2. Fork the Github repository.
3. Clone it into your IDE. A JDK 8 must be configured. Don’t use a JRE.
4. Create a feature branch, e.g. issue#111
5. Write a testcase and modify the code.
6. Commit and push the feature branch.
7. The push message gives you a link to execute for creating the pull request.

Eclipse

1. Clone repository.
2. File > Import > Existing Maven projects
3. Choose parent folder of your jxls repo folder.
4. Projects will be imported as nested projects.

Codestyle

• Java 8 syntax (starting from Jxls 2.9.0)
• Closing { at end of line.
• Use spaces instead of tabs.
• Use @Override annotation.
• Test case class name must end with ‘Test’.

Writing template based testcases

Use JxlsTester for writing a template based testcase. The template file must have the name of the test class and must be in the same package in source folder ‘src/test/resources’ (e.g. /jxls-poi/src/test/resources/org/jxls/templatebasedtests/ConditionalFormattingTest.xlsx). The method processTemplate creates the output file in the target folder with _output as part of the name. Use JxlsTester.getWorkbook() for verifying the output file.

    // Test
    JxlsTester tester = JxlsTester.xlsx(getClass());
    tester.processTemplate(context);

    // Verify
    try (TestWorkbook w = tester.getWorkbook()) {

As an alternative you can use createTransformerAndProcessTemplate() instead of processTemplate() if you want to check, edit or exchange the transformer instance.

If each test method of your testclass use its own template file you can speficy the method name in the xlsx() call as the 2nd arg (example: NestedSumsTest).

Use xls() if you must use the old XLS format. Prefer the XLSX format.