```
public class ColumnHelper
extends java.lang.Object
```
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!

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`CTCols`	`addCleanColIntoCols(CTCols cols, CTCol newCol)`
`void`	`cleanColumns()`
`CTCol`	`cloneCol(CTCols cols, CTCol col)`
`boolean`	`columnExists(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)`
`CTCol`	`getColumn(long index, boolean splitColumns)`	Returns the Column at the given 0 based index
`CTCol`	`getColumn1Based(long index1, boolean splitColumns)`	Returns the Column at the given 1 based index.
`int`	`getIndexOfColumn(CTCols cols, CTCol searchCol)`
`void`	`setColBestFit(long index, boolean bestFit)`
`void`	`setColDefaultStyle(long index, int styleId)`
`void`	`setColDefaultStyle(long index, CellStyle style)`
`void`	`setColHidden(long index, boolean hidden)`
`void`	`setColumnAttributes(CTCol fromCol, CTCol toCol)`
`void`	`setColWidth(long index, double width)`
`void`	`setCustomWidth(long index, boolean bestFit)`
`static void`	`sortColumns(CTCols newCols)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

public ColumnHelper(CTWorksheet worksheet)

public CTCols addCleanColIntoCols(CTCols cols,
                                  CTCol newCol)

public static void sortColumns(CTCols newCols)

public CTCol cloneCol(CTCols cols,
                      CTCol col)

public CTCol getColumn(long index,
                       boolean splitColumns)

Returns the Column at the given 0 based index

public void setColumnAttributes(CTCol fromCol,
                                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,
                               CellStyle style)

public void setColDefaultStyle(long index,
                               int styleId)

public int getColDefaultStyle(long index)

public int getIndexOfColumn(CTCols cols,
                            CTCol searchCol)

Class ColumnHelper