Excel Template Framework and Java Class Library Integration Index
Excel Templateer framework is an open source framework for generating Excel documents. The main feature is that the template is used to define the style and structure of Excel documents.The template engine in the Java class library is a tool for analyzing and filling the template, which can be used to realize the function of dynamically generating various documents.This article will introduce how to integrate the Excel Templateer framework and template engine in the Java project.
1. Use of Excel Templateer framework
The Excel Templateer framework is simple and flexible. Before use, you need to define an Excel template. The template can contain various styles and place occupies.The placeholders are used to mark the position of the filling data, such as using {{name}} to represent the position of the name.Then the API provided by the Excel Template frame can dynamically replace the seat occupies and generate the final Excel document.
2. Integration of template engine
In the Java project, we can use the template engine to analyze the template required for the Excel Templateer framework and dynamically fill the data.The commonly used template engines include FreeMarker, Velocity, etc., here are described in FREMARKER as an example.
1. Introduce freemarker dependencies
The dependencies of the introduction of FreeMarker in the pom.xml file of the project:
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>2.3.30</version>
</dependency>
2. Prepare Excel template
First prepare an Excel template file, named the template file as template.xlsx or template.xls, and place the style and placeholder in the template file according to the requirements.
3. Use FreeMarker parsing template
Use FreeMarker to parse the Excel template and replace the placeholders in the Java code:
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
import java.io.*;
import java.util.HashMap;
import java.util.Map;
public class ExcelGenerationUtil {
public static void generateExcelUsingTemplater() throws IOException, TemplateException {
// Load freemarker configuration
Configuration configuration = new Configuration(Configuration.VERSION_2_3_30);
configuration.setDefaultEncoding("UTF-8");
configuration.setClassForTemplateLoading(ExcelGenerationUtil.class, "/templates");
// Load the Excel template
Template template = configuration.getTemplate("template.xlsx");
// Ready to fill in data
Map<String, Object> data = new HashMap<>();
data.put("name", "John Doe");
data.put("age", 30);
// Create the output stream to generate the final Excel document
FileOutputStream output = new FileOutputStream("output.xlsx");
// Fill in the data and generate the final Excel document
template.process(data, new OutputStreamWriter(output));
}
public static void main(String[] args) {
try {
generateExcelUsingTemplater();
} catch (IOException | TemplateException e) {
e.printStackTrace();
}
}
}
In the above code, we loaded the Freemarker configuration through the @Configuration class and specify the path of the template file.Then use the Template class to load the template file and prepare to fill in the data.Finally, the data is filled in the template.process method to the template, and the final Excel document is generated.
Summarize:
This article introduces the integration of the Excel Templateer framework and the template engine in the Java class library. By using a template engine to analyze Excel templates and fill in data, the Excel document can be easily generated.Taking FreeMarker as an example, I introduced how to use its parsing templates and generate Excel documents.Readers can choose the appropriate template engine according to actual needs to complete the generation of Excel documents.
