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 newCol) |
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.
|
int |
getIndexOfColumn(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol searchCol) |
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 org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols addCleanColIntoCols(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol newCol)
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 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 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 searchCol)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.