单元格对齐设置
Contents
[
Hide
]
Aspose.Cells - 单元格对齐设置
Aspose.Cells 提供一个称为 Workbook 的类,表示 Excel 文件。Workbook 类包含一个 WorksheetCollection,允许访问 Excel 文件中的每个工作表。工作表由 Worksheet 类表示。
Worksheet 类提供一个 Cells 集合。Cells 集合中的每个项代表 Cell 类的对象。
Aspose.Cells 在 Cell 类中提供 setStyle 方法,用于设置单元格的格式。Style 类提供了有用的属性来配置字体设置。
使用 TextAlignmentType 枚举选择任何文本对齐类型。
Java
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();
//Adding the current system date to "A1" cell
Cell cell = cells.get("A1");
Style style = cell.getStyle();
//Adding some value to the "A1" cell
cell.setValue("Visit Aspose!");
//Setting the horizontal alignment of the text in the "A1" cell
style.setHorizontalAlignment(TextAlignmentType.CENTER);
//Saved style
cell.setStyle(style);
Apache POI SS - HSSF & XSSF - 单元格对齐设置
HSSFCellStyle 使用 Apache POI API 为单元格提供样式对齐。
Java
public static void main(String[] args) throws IOException
{
// The path to the documents directory.
String dataDir = Utils.getDataDir(ApacheCellAlignment.class);
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row = sheet.createRow(2);
createCell(wb, row, 0, HSSFCellStyle.ALIGN_CENTER);
createCell(wb, row, 1, HSSFCellStyle.ALIGN_CENTER_SELECTION);
createCell(wb, row, 2, HSSFCellStyle.ALIGN_FILL);
createCell(wb, row, 3, HSSFCellStyle.ALIGN_GENERAL);
createCell(wb, row, 4, HSSFCellStyle.ALIGN_JUSTIFY);
createCell(wb, row, 5, HSSFCellStyle.ALIGN_LEFT);
createCell(wb, row, 6, HSSFCellStyle.ALIGN_RIGHT);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream(dataDir + "ApahceAlignment.xls");
wb.write(fileOut);
fileOut.close();
System.out.println("Done.");
}
/**
\* Creates a cell and aligns it a certain way.
\*
\* @param wb the workbook
\* @param row the row to create the cell in
\* @param column the column number to create the cell in
\* @param align the alignment for the cell.
*/
private static void createCell(HSSFWorkbook wb, HSSFRow row, int column, int align) {
HSSFCell cell = row.createCell(column);
cell.setCellValue("Align It");
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment((short)align);
cell.setCellStyle(cellStyle);
}
下载运行代码
下载示例代码
有关详细信息,请访问 配置对齐设置