更改单元格对齐方式并保持现有格式
Contents
[
Hide
]
可能的使用场景
有时,您想要更改多个单元格的对齐方式,但又想保留现有的格式。Aspose.Cells允许您使用 StyleFlag.Alignments 属性进行操作。如果将其设置为 true,则对齐方式的更改将生效,否则不会生效。请注意,作为参数传递给 Range.applyStyle() 方法的是 StyleFlag 对象,该方法实际上将格式应用于单元格范围。
更改单元格对齐方式并保留现有格式
以下示例代码加载了示例Excel文件,创建了范围并在水平和垂直方向上进行了居中对齐,同时保留了现有的格式。以下屏幕截图比较了示例Excel文件和输出Excel文件,显示了所有单元格的现有格式都相同,只是单元格现在在水平和垂直方向上都居中对齐。
示例代码
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// Load sample Excel file containing cells with formatting. | |
Workbook wb = new Workbook(srcDir + "sampleChangeCellsAlignmentAndKeepExistingFormatting.xlsx"); | |
// Access first worksheet. | |
Worksheet ws = wb.getWorksheets().get(0); | |
// Create cells range. | |
Range rng = ws.getCells().createRange("B2:D7"); | |
// Create style object. | |
Style st = wb.createStyle(); | |
// Set the horizontal and vertical alignment to center. | |
st.setHorizontalAlignment(TextAlignmentType.CENTER); | |
st.setVerticalAlignment(TextAlignmentType.CENTER); | |
// Create style flag object. | |
StyleFlag flag = new StyleFlag(); | |
// Set style flag alignments true. It is most crucial statement. | |
// Because if it will be false, no changes will take place. | |
flag.setAlignments(true); | |
// Apply style to range of cells. | |
rng.applyStyle(st, flag); | |
// Save the workbook in XLSX format. | |
wb.save(outDir + "outputChangeCellsAlignmentAndKeepExistingFormatting.xlsx", SaveFormat.XLSX); |