How to export excel using java

Steps for java to export excel: 1. Import the dependencies of the Apache POI library; 2. Use the XSSFWorkbook class to create a new Excel workbook; 3. Use the createSheet method to create a new worksheet in the workbook ; 4. Use the createRow method to create a new row in the worksheet; 5. Use the createCell method to create a new cell in the row and set its value; 6. Set the cell style; 7. Run the code to export excel.

#In Java, we can use the Apache POI library to export Excel files. Apache POI is a Java library for creating, reading, and modifying files in Microsoft Office formats, including Excel files.

The following are the steps to export Excel files using Java:

Import the dependencies of the Apache POI library. In the Maven project, you can add the following dependencies in the pom.xml file:

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

Create a workbook (Workbook) object. You can use the XSSFWorkbook class to create a new Excel workbook. For example:

Workbook workbook = new XSSFWorkbook();

Create a worksheet (Sheet) object. Use the createSheet method to create a new worksheet in the workbook. For example:

Sheet sheet = workbook.createSheet("Sheet1");

Create a row (Row) object. Use the createRow method to create a new row in the worksheet. For example:

Row row = sheet.createRow(0);

Create a cell (Cell) object. Use the createCell method to create a new cell in the row and set its value. For example:

Cell cell = row.createCell(0);
cell.setCellValue("Hello");

Set cell style. You can use the CellStyle class to set the style of a cell, such as setting fonts, colors, borders, etc. For example:

CellStyle cellStyle = workbook.createCellStyle();
Font font = workbook.createFont();
font.setBold(true);
font.setColor(IndexedColors.RED.getIndex());
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
保存Excel文件。使用FileOutputStream类将工作簿保存到文件中。例如：
try (FileOutputStream fileOut = new FileOutputStream("output.xlsx")) {
    workbook.write(fileOut);
}

The complete sample code is as follows:

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
import java.io.IOException;
public class ExcelExporter {
    public static void main(String[] args) {
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("Sheet1");
        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        cell.setCellValue("Hello");
        CellStyle cellStyle = workbook.createCellStyle();
        Font font = workbook.createFont();
        font.setBold(true);
        font.setColor(IndexedColors.RED.getIndex());
        cellStyle.setFont(font);
        cell.setCellStyle(cellStyle);
        try (FileOutputStream fileOut = new FileOutputStream("output.xlsx")) {
            workbook.write(fileOut);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

After running this code, an Excel file named output.xlsx will be created in the project directory, which contains an Excel file with a red Cell with thick text "Hello".

These are the basic steps to export Excel files using Java. Using the Apache POI library, you can further manipulate workbooks, worksheets and cells, such as adding data, setting formats, merging cells, etc.

The above is the detailed content of How to export excel using java. For more information, please follow other related articles on the PHP Chinese website!