com.aspose.cells

com.aspose.cells

Class Column

  • java.lang.Object
    • com.aspose.cells.Column
public class Column 
extends java.lang.Object

Represents a single column in a worksheet.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

Style style = workbook.createStyle();
//Setting the background color to Blue
style.setBackgroundColor(Color.getBlue());

//Setting the foreground color to Red
style.setForegroundColor(Color.getRed());

//setting Background Pattern
style.setPattern(BackgroundType.DIAGONAL_STRIPE);

//New Style Flag
StyleFlag styleFlag = new StyleFlag();

//Set All Styles
styleFlag.setAll(true);

//Get first Column
Column column = worksheet.getCells().getColumns().get(0);

//Apply Style to first Column
column.applyStyle(style, styleFlag);

//Saving the Excel file
workbook.save("D:\\book1.xls");

Property Getters/Setters Summary
bytegetGroupLevel()
Gets the group level of the column.
intgetIndex()
Gets the index of this column.
booleanisHidden()
void
setHidden(booleanvalue)
           Indicates whether the column is hidden.
StylegetStyle()
Gets the style of this column.
doublegetWidth()
void
setWidth(doublevalue)
           Gets and sets the column width in unit of characters.
 
Method Summary
voidapplyStyle(Style style, StyleFlag flag)
Applies formats for a whole column.
 

    • Property Getters/Setters Detail

      • getIndex

        public int getIndex()
        Gets the index of this column.

      • getWidth/setWidth

        public double getWidth() / public void setWidth(double value)
        Gets and sets the column width in unit of characters.

      • getGroupLevel

        public byte getGroupLevel()
        Gets the group level of the column.

      • isHidden/setHidden

        public boolean isHidden() / public void setHidden(boolean value)
        Indicates whether the column is hidden.

      • getStyle

        public Style getStyle()
        Gets the style of this column. You have to call Column.ApplyStyle() method to save your changing with the row style, otherwise it will not effect.

    setWidth

    public voidsetWidth(doublevalue)
    Gets and sets the column width in unit of characters.

    setHidden

    public voidsetHidden(booleanvalue)
    Indicates whether the column is hidden.

    • Method Detail

      • applyStyle

        public void applyStyle(Style style, StyleFlag flag)
        Applies formats for a whole column.
        Parameters:
        style - The style object which will be applied.
        flag - Flags which indicates applied formatting properties.