How to use the Light Excel Reader framework to write an Excel file writing operation in the Java class library
Use Light Excel Reader framework to write an Excel file writing operation in the Java class library
introduce:
Light Excel Reader is an open source Java class library for processing Excel files.It provides support for reading and writing operations of Excel files.In this article, we will focus on how to use the Light Excel Reader framework in the Java library to perform the Excel file writing operation.
step:
1. Add dependencies:
First, you need to add Light Excel Reader to the project.You can add the following dependencies to your project by using Maven or Gradle Construction Tools:
Maven：
<dependency>
<groupId>com.github.qqupp</groupId>
<artifactId>lightexcelreader</artifactId>
<version>1.5.1</version>
</dependency>
Gradle：
groovy
implementation 'com.github.qqupp:lightexcelreader:1.5.1'
2. Create an excel file:
In the Java code, you can create a new Excel file with API provided by Light Excel Reader.The following is a sample code for creating an Excel file with a header and data:
import com.qqupp.excel.LightExcelWriter;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
public class ExcelWriterExample {
public static void main(String[] args) {
String filePath = "example.xlsx";
// Prepare data
List<List<Object>> data = new ArrayList<>();
data.add (Arrays.aslist ("Name", "Age", "Gender");
data.add (Arrays.aslist ("Zhang San", 20, "Male");
data.add (Arrays.aslist ("Li Si", 30, "Female");
data.add (Arrays.aslist ("Wang Wu", 25, "Men");
try (FileOutputStream fileOutputStream = new FileOutputStream(filePath);
LightExcelWriter excelWriter = new LightExcelWriter(fileOutputStream)) {
// Write into the header
excelWriter.writeRow(data.get(0));
// data input
for (int i = 1; i < data.size(); i++) {
excelWriter.writeRow(data.get(i));
}
// Save the excel file
excelWriter.finish();
System.out.println ("Excel file has been successfully written!");
} catch (IOException e) {
e.printStackTrace();
}
}
}
3. Run code:
After running the above code, it will create an Excel file called "Example.xlsx", which contains heads and data rows.
Summarize:
In this article, we discussed how to use the Light Excel Reader framework to write an Excel file writing operation in the Java library.By using Light Excel Reader, you can easily create and write the Excel file to make the data easier to manage and analyze.Hope this article will help you!
