要使用java.awt.Color创建XSSFColor,可以按照以下步骤执行:
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import java.awt.Color;
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
CellStyle cellStyle = workbook.createCellStyle();
Color color = new Color(255, 0, 0); // 创建红色
XSSFColor xssfColor = new XSSFColor(color);
cellStyle.setFillForegroundColor(xssfColor);
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellStyle(cellStyle);
FileOutputStream fileOutputStream = new FileOutputStream("workbook.xlsx");
workbook.write(fileOutputStream);
fileOutputStream.close();
完整的示例代码如下所示:
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import java.awt.Color;
import java.io.FileOutputStream;
import java.io.IOException;
public class ApachePOIExample {
public static void main(String[] args) throws IOException {
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
CellStyle cellStyle = workbook.createCellStyle();
Color color = new Color(255, 0, 0);
XSSFColor xssfColor = new XSSFColor(color);
cellStyle.setFillForegroundColor(xssfColor);
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellStyle(cellStyle);
FileOutputStream fileOutputStream = new FileOutputStream("workbook.xlsx");
workbook.write(fileOutputStream);
fileOutputStream.close();
System.out.println("Workbook created successfully.");
}
}
运行该代码将创建一个名为"workbook.xlsx"的Excel文件,在第一个单元格中使用红色填充。
上一篇:Apache POI 4.0.x 是否支持 Java 11?
下一篇:Apache POI 4.1 - 新的XSSFWorkbook导致POIXMLException: 不支持严格的OOXML