public class ColumnHelper
extends java.lang.Object
Constructor and Description |
---|
ColumnHelper(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet) |
Modifier and Type | Method and Description |
---|---|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols |
addCleanColIntoCols(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col) |
void |
cleanColumns() |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol |
cloneCol(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col) |
boolean |
columnExists(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
long index)
Does the column at the given 0 based index exist
in the supplied list of column definitions?
|
int |
getColDefaultStyle(long index) |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol |
getColumn(long index,
boolean splitColumns)
Returns the Column at the given 0 based index
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol |
getColumn1Based(long index1,
boolean splitColumns)
Returns the Column at the given 1 based index.
|
boolean |
getCustomWidth(long index) |
int |
getIndexOfColumn(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col) |
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol |
getOrCreateColumn1Based(long index1,
boolean splitColumns)
Return the CTCol at the given (0 based) column index,
creating it if required.
|
void |
setColBestFit(long index,
boolean bestFit) |
void |
setColDefaultStyle(long index,
CellStyle style) |
void |
setColDefaultStyle(long index,
int styleId) |
void |
setColHidden(long index,
boolean hidden) |
void |
setColumnAttributes(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol fromCol,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol toCol) |
void |
setColWidth(long index,
double width) |
void |
setCustomWidth(long index,
boolean bestFit) |
static void |
sortColumns(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols newCols) |
public ColumnHelper(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet)
public void cleanColumns()
public static void sortColumns(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols newCols)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol cloneCol(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol getColumn(long index, boolean splitColumns)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol getColumn1Based(long index1, boolean splitColumns)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols addCleanColIntoCols(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col)
public boolean columnExists(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols, long index)
public void setColumnAttributes(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol fromCol, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol toCol)
public void setColBestFit(long index, boolean bestFit)
public void setCustomWidth(long index, boolean bestFit)
public boolean getCustomWidth(long index)
public void setColWidth(long index, double width)
public void setColHidden(long index, boolean hidden)
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol getOrCreateColumn1Based(long index1, boolean splitColumns)
public void setColDefaultStyle(long index, CellStyle style)
public void setColDefaultStyle(long index, int styleId)
public int getColDefaultStyle(long index)
public int getIndexOfColumn(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col)
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.