Cell alignment

The following example shows you how to set cell alignment including horizontal, vertical, text wrap, rotation and indent.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;
import com.independentsoft.office.spreadsheet.styles.CellAlignment;
import com.independentsoft.office.spreadsheet.styles.CellFormat;
import com.independentsoft.office.spreadsheet.styles.HorizontalAlignment;
import com.independentsoft.office.spreadsheet.styles.VerticalAlignment;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();

            CellFormat centerFormat = new CellFormat();
            CellAlignment centerAlign = new CellAlignment();
            centerAlign.setHorizontalAlignment(HorizontalAlignment.CENTER);
            centerAlign.setVerticalAlignment(VerticalAlignment.TOP);
            centerFormat.setAlignment(centerAlign);
            centerFormat.setApplyAlignment(true);

            Cell a1 = new Cell("Center + Top");
            a1.setFormat(centerFormat);
            sheet.set("A1", a1);

            CellFormat wrapFormat = new CellFormat();
            CellAlignment wrapAlign = new CellAlignment();
            wrapAlign.setWrapText(true);
            wrapAlign.setHorizontalAlignment(HorizontalAlignment.LEFT);
            wrapFormat.setAlignment(wrapAlign);
            wrapFormat.setApplyAlignment(true);

            Cell b1 = new Cell("This is a long text that will wrap inside the cell");
            b1.setFormat(wrapFormat);
            sheet.set("B1", b1);

            CellFormat rotateFormat = new CellFormat();
            CellAlignment rotateAlign = new CellAlignment();
            rotateAlign.setTextRotation(45);
            rotateAlign.setHorizontalAlignment(HorizontalAlignment.CENTER);
            rotateFormat.setAlignment(rotateAlign);
            rotateFormat.setApplyAlignment(true);

            Cell c1 = new Cell("Rotated 45");
            c1.setFormat(rotateFormat);
            sheet.set("C1", c1);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Cell alignment

Need help? Ask our developers: