多个样式到Excel单元格POI [英] Multiple Styles to Excel Cell POI

问题描述

我想将颜色应用于单元格以及格式化单元格值（例如日期，金额）。但是当我应用两个单元格样式时，只有最后一个样式应用于单元格。

I want to apply colour to cell as well as Format Cell value(e.g. Date,Amount).But when I am applying two Cell Style only the last style is gets applied on cell.

//before this colourCellStyle and dateCellStyle are the formatting style
cell9 = row.createCell(9);
cell9.setCellValue(getLoadDate());
cell9.setCellStyle(colourCellStyle);
cell9.setCellStyle(dateCellStyle);

推荐答案

多个单元格样式无法应用于单个细胞。应用的最后一个单元格样式将覆盖 Cell 上任何预先存在的单元格样式。设置多个 CellStyle 将不会合并每种样式的设置属性。

Multiple cell styles cannot be applied to a single Cell. The last cell style applied will overwrite any pre-existing cell style on the Cell. Setting multiple CellStyles won't combined the set attributes of each style.

解决方案是创建另一个 CellStyle 具有其他 CellStyle 的所需属性。您可以使用 cloneStyleFrom 方法以一个 CellStyle 的属性开头。

The solution is to create another CellStyle that has the desired attributes of both of the other CellStyles. You can use the cloneStyleFrom method to start with the attributes of one CellStyle.

CellStyle combined = workbook.createCellStyle();
combined.cloneStyleFrom(colourCellStyle);
combined.setDataFormat(dateCellStyle.getDataFormat());
// You can copy other attributes to "combined" here if desired.

cell9.setCellStyle(combined);

此技术可以推广用于克隆任何现有的单元格样式并从第二个现有单元格样式复制单个属性。与往常一样，重用任何现有的 CellStyle ，但如果需要不同的属性组合，则必须创建并使用新的 CellStyle 。

This technique can be generalized to clone any existing cell style and copy individual attributes from a second existing cell style. As always, reuse any existing CellStyles, but if a different combination of attributes is required, then you must create and use a new CellStyle.

这篇关于多个样式到Excel单元格POI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！