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?
(给定的基于 0 的索引处的列是否存在于提供的列定义列表中?)
|
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
(返回基于 0 的给定索引处的列)
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol |
getColumn1Based(long index1, boolean splitColumns)
Returns the Column at the given 1 based index.
(返回基于 1 的给定索引处的 Column。)
|
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.
(返回给定(基于 0)列索引处的 CTCol,如果需要,创建它。)
|
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.