Cell Alignment Settings

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 for 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 a value to the "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 the 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 + "ApacheAlignment.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

• GitHub

Download Sample Code

• GitHub

For more details, visit Configuring Alignment Settings.