java import org.apache.poi.xssf.streaming.SXSSFWorkbook; import org.apache.poi.ss.usermodel.SXSSFSheet; import org.apache.poi.ss.usermodel.SXSSFRow; import org.apache.poi.ss.usermodel.SXSSFCell;

import java.io.FileOutputStream;

public class ExcelWriterExample { public static void main { // 创建干活簿对象 SXSSFWorkbook workbook = new SXSSFWorkbook;

    // 创建sheet对象
    SXSSFSheet sheet = workbook.createSheet;
    // 设置列宽阔和行高大
    sheet.setDefaultColumnWidth;
    sheet.setDefaultRowHeight 500);
    // 创建行对象
    SXSSFRow row = sheet.createRow;
    // 创建单元格并写入数据
    SXSSFCell cell = row.createCell;
    cell.setCellValue;
    // 保存Excel文件
    try ) {
        workbook.write;
    } catch  {
        e.printStackTrace;
    } finally {
        // 释放底层材料
        workbook.dispose;
    }
}

}