从另一个XSSFCellStyle创建新的XSSFCellStyle或克隆XSSFCellStyle(POI APACHE)

问题描述

我需要一个新的XSSFCellStyle，因为我必须更改一些样式.

I need a new XSSFCellStyle because I have to change some stylings.

我只有一个XSSFCellStyle-我没有它属于的XSSFCell.因此，我也无法访问相关的XSSFSheet或XSSFWorkbook.

I only have a XSSFCellStyle - I don't have the XSSFCell it belongs to. Thus I also don't have access to the related XSSFSheet or XSSFWorkbook.

• 我没有XSSFWorkbook，所以我不能打电话给workbook.createCellStyle().
• XSSFCellStyle构造函数至少需要一个我也没有的StylesTable(因为我找不到从旧的XSSFCellStyle中获取它的方法).
• cellStyle.cloneStyleFrom(XSSFCellStyle Source)并没有真正克隆样式(它或多或少只是一个具有相同指针的副本，因此，如果我对一个cellStyle进行更改，则"cloned" cellStyle会具有相同的更改).

• I don't have the XSSFWorkbook therefore I can't call workbook.createCellStyle().
• The XSSFCellStyle constructor needs at least a StylesTable which I also don't have (because I couldn't find a way to get it from the old XSSFCellStyle).
• The cellStyle.cloneStyleFrom(XSSFCellStyle Source) doesn't really clone the style (it's more or less just a copy with the same pointers, so if I change something on one cellStyle the "cloned" cellStyle has the same changes).

如何获取新的XSSFCellStyle?

关于，winklerrr

Regards, winklerrr

推荐答案

XSSFCellStyle上有一个clone()方法.
我不知道为什么，但我最初没有看到它.我不好.

There is a clone() method available on the XSSFCellStyle.
I don't know why but I didn't see it in the first place. My bad.

这篇关于从另一个XSSFCellStyle创建新的XSSFCellStyle或克隆XSSFCellStyle(POI APACHE)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！