|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.poi.xssf.usermodel.helpers.ColumnHelper
public class ColumnHelper
Helper class for dealing with the Column settings on a CTWorksheet (the data part of a sheet). Note - within POI, we use 0 based column indexes, but the column definitions in the XML are 1 based!
Constructor Summary | |
---|---|
ColumnHelper(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet)
|
Method Summary | |
---|---|
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. |
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)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public ColumnHelper(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet)
Method Detail |
---|
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 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)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |