JarCastingsimter-jxls-ext [中文]
Simter Jxls Extensions. Includes:
-
Common Functions
- Format number: fn.format(1123456789.456, '#,###.00') > 1,123,456,789.56
- Round number: fn.round(45.678, 2) > 45.68
- Convert string to int: fn.toInt('123') > 123
- Concat multipul strings: fn.concat('ab', 'c', ...) > 'abc'
- Format java8 date/time: fn.format(LocalDateTime.now(), 'yyyy-MM-dd HH:mm:ss') > 2017-01-01 12:30:50
-
EachMergeCommand:
jx:each-merge, for auto merge cells
See the usage code bellow.
Installation
<dependency>
<groupId>tech.simter</groupId>
<artifactId>simter-jxls-ext</artifactId>
<version>1.0.0</version>
</dependency>
Requirement
- Jxls 2+
- Java 8+
Usage
Common Functions
Context context = new Context();
// inject common-functions
context.putVar("fn", CommonFunctions.getSingleton());
// other data
context.putVar("num", new BigDecimal("123.456"));
context.putVar("datetime", LocalDateTime.now());
context.putVar("date", LocalDate.now());
context.putVar("time", LocalTime.now());
context.putVar("str", "123");
// render template
InputStream template = ...;
OutputStream output = ...;
JxlsHelper.getInstance().processTemplate(template, output, context);
Check the unit test code from CommonFunctionsTest.java. The template and render result show bellow:
EachMergeCommand - Auto merge cells
// global add custom each-merge command to XlsCommentAreaBuilder
XlsCommentAreaBuilder.addCommandMapping(EachMergeCommand.COMMAND_NAME, EachMergeCommand.class);
// generate a main-sub structure data
Context context = new Context();
context.putVar("rows", generateRowsData());
// render template
InputStream template = ...;
OutputStream output = ...;
JxlsHelper.getInstance().processTemplate(template, output, context);
The generateRowsData() method generates the bellow structure data:
[
{
sn: 1,
name: 'row1',
subs: [
{sn: '1-1', name: 'row1sub1'},
...
]
},
...
]
Check the unit test code from EachMergeCommandTest.java. The template and render result show bellow:
Build
mvn clean package
Deploy
First take a look at simter-parent deploy config.
Deploy to LAN Nexus Repository
mvn clean deploy -P lan
Deploy to Sonatype Repository
mvn clean deploy -P sonatype
After deployed, login into https://oss.sonatype.org. Through Staging Repositories, search this package, then close and release it. After couple hours, it will be synced to Maven Central Repository.
Deploy to Bintray Repository
mvn clean deploy -P bintray
Will deploy to https://api.bintray.com/maven/simter/maven/tech.simter:simter-jxls-ext/;publish=1. So first create a package https://bintray.com/simter/maven/tech.simter:simter-jxls-ext on Bintray. After deployed, check it from https://jcenter.bintray.com/tech/simter/simter-jxls-ext.
