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);
//Add new Style to Workbook
Style style = workbook.getStyles().get(workbook.getStyles().add());
//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 |
byte | getGroupLevel() | |
|
Gets the group level of the column.
|
int | getIndex() | |
|
Gets the index of this column.
|
boolean | isHidden() | |
void | setHidden(boolean value) | |
|
Indicates whether the column is hidden.
|
Style | getStyle() | |
|
Gets the style of this column.
|
double | getWidth() | |
void | setWidth(double value) | |
|
Gets and sets the column width in unit of charaters.
|
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 charaters.
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.
-
Applies formattings for a whole column.
- Parameters:
style
- The style object which will be applied.flag
- Flags which indicates applied formatting properties.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.