|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.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)
|
void |
setColBestFit(long index,
boolean bestFit)
|
void |
setColDefaultStyle(long index,
org.apache.poi.ss.usermodel.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 |
---|
equals, 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)
public void setColDefaultStyle(long index, org.apache.poi.ss.usermodel.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 |