Cell Alignment Settings
Contents
[
Hide
]
Aspose.Cells - Cell Alignment Settings
Aspose.Cells provides a class, Workbook, that represents an Excel file. The Workbook class contains a WorksheetCollection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class.
The Worksheet class provides a Cells collection. Each item in the Cells collection represents an object of the Cell class.
Aspose.Cells provides the setStyle method in the Cell class that is used a cell’s formatting. The Style class provides useful properties for configuring font settings.
Select any text alignment type using the TextAlignmentType enumeration.
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 - Cell Alignment Settings
HSSFCellStyle provides the style for alignment in cells using 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);
}Download Running Code
Download Sample Code
For more details, visit Configuring Alignment Settings.