Excel Templateer Framework Java Library Development Guide
Excel Templateer framework is a Java library for generating an excel document.It provides a simple and flexible API that allows developers to generate Excel templates in various formats through the Java code, including tables, charts, formulas, and data formats.
Before starting to use the Excel Templateer framework, you need to install the Java environment and set it to one of your project dependencies.You can perform this operation by adding the following dependencies to your project configuration file:
<dependency>
<groupId>com.github.sdorra</groupId>
<artifactId>excel-templater</artifactId>
<version>1.3.2</version>
</dependency>
Next, you need to create an Excel template file.You can use Excel software to create this file and save it in the `.xlsx` format.In the template file, you can define the content to be generated, such as title, column head, data and charts.You can also use Excel's formulas and format functions.
Once there is a template file, you can use the Excel Templateer framework to fill and generate Excel documents.Below is a simple example, demonstrating how to use the Excel Templateer framework to generate an Excel document containing data and charts:
import com.github.sdorra.excel.Excel;
import com.github.sdorra.excel.ExcelBuilder;
import com.github.sdorra.excel.Table;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
public class ExcelTemplaterExample {
public static void main(String[] args) {
try {
// 1. Load the Excel template file
File templateFile = new File("template.xlsx");
ExcelBuilder excelBuilder = Excel.load(templateFile);
// 2. Get the workbook and worksheet
Workbook workbook = excelBuilder.getWorkbook();
Sheet sheet = workbook.getSheetAt(0);
// 3. Create a form and fill in data
Table table = excelBuilder.getTableBuilder()
.newTable()
.fromSheet(sheet)
.build();
table.addCell(1, 1, "John Doe");
table.addCell(2, 1, "johndoe@example.com");
table.addCell(3, 1, "New York");
// 4. Generate excel documentation
FileOutputStream outputStream = new FileOutputStream("output.xlsx");
excelBuilder.build().write(outputStream);
outputStream.close();
System.out.println ("Excel document successfully!"););
} catch (IOException e) {
e.printStackTrace();
}
}
}
In the above examples, we first load the template file and then get the workbook and worksheet.Next, we created a form and filled some data in it.Finally, we use the `ExcelBuilder` to generate the output file and write it into the disk.
Using the Excel Templateer framework, you can easily generate highly customized Excel documents.You can perform more complicated operations according to your needs, such as adding charts, setting formulas, application data formats, etc.
To sum up, the Excel Templateer framework is a powerful and easy -to -use Java class library that can be used to generate Excel documents.By using this framework, you can generate complex Excel templates by simple Java code, so that your data is presented in a professional and visual way.
