public class HSSFOptimiser
extends java.lang.Object
Constructor and Description |
---|
HSSFOptimiser() |
Modifier and Type | Method and Description |
---|---|
static void |
optimiseCellStyles(HSSFWorkbook workbook)
Goes through the Wokrbook, optimising the cell styles by removing duplicate ones, and ones that aren't used.
(浏览 Wokrbook,通过删除重复的和未使用的来优化单元格样式。)
|
static void |
optimiseFonts(HSSFWorkbook workbook)
Goes through the Workbook, optimising the fonts by removing duplicate ones.
(浏览工作簿,通过删除重复字体来优化字体。)
|
public static void optimiseFonts(HSSFWorkbook workbook)
HSSFCellStyle
and
HSSFRichTextString
. Any other font uses (eg charts, pictures) may well end up broken! This can be a slow operation, especially if you have lots of cells, cell styles or rich text strings
(浏览工作簿,通过删除重复字体来优化字体。目前,仅适用于 HSSFCellStyle 和 HSSFRichTextString 中使用的字体。任何其他字体使用(例如图表、图片)都可能最终被破坏!这可能是一个缓慢的操作,尤其是当您有大量单元格、单元格样式或富文本字符串时)
workbook
- The workbook in which to optimise the fonts
(工作簿 - 优化字体的工作簿)
public static void optimiseCellStyles(HSSFWorkbook workbook)
optimiseFonts(HSSFWorkbook)
first.
(浏览 Wokrbook,通过删除重复的和未使用的来优化单元格样式。为获得最佳结果,请首先通过调用 optimiseFonts(HSSFWorkbook) 来优化字体。)
workbook
- The workbook in which to optimise the cell styles
(工作簿 - 优化单元格样式的工作簿)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.