java - Apache poi 单元格样式，带有颜色和右对齐

Question

样式单元格颜色&&值右对齐是否像这样:

 XSSFColor color = new XSSFColor(new Color(43,150,150));
 XSSFCellStyle cellStyle = myWorkBook.createCellStyle();
 cellStyle.setFillForegroundColor(color);
 cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
 cellStyle.setAlignment(HorizontalAlignment.RIGHT);
 //cellStyle.setAlignment(CellStyle.ALIGN_RIGHT);

单元格颜色有效，但单元格值右对齐无效。

Answer 1

您的问题无法重现。使用当前的 apache poi 4.1.1，您的代码片段可以按预期工作。

让我们来个Minimal, Reproducible Example以证明它确实有效。

代码:

import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.xssf.usermodel.*;

class CreateExcelCellStyleAlingmentAndColor {

 public static void main(String[] args) throws Exception {

  try (XSSFWorkbook workbook = new XSSFWorkbook(); 
       FileOutputStream fileout = new FileOutputStream("./Excel.xlsx") ) {

   XSSFColor color = new XSSFColor(new java.awt.Color(43,150,150), null);
   XSSFCellStyle cellStyle = workbook.createCellStyle();
   cellStyle.setFillForegroundColor(color);
   cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
   cellStyle.setAlignment(HorizontalAlignment.RIGHT);

   XSSFSheet sheet = workbook.createSheet();
   XSSFCell cell = sheet.createRow(0).createCell(0);
   cell.setCellValue("A1");
   cell.setCellStyle(cellStyle);

   workbook.write(fileout);
  }

 }
}

结果:

你看，彩色且右对齐。