Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## org.apache.poi.xssf.usermodel.helpers
Class ColumnHelper

    java.lang.Object
      org.apache.poi.xssf.usermodel.helpers.ColumnHelper

    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!

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.
`static double` | `getColumnWidth(XSSFSheet sheet, int column, boolean useMergedCells)`
`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

### ColumnHelper

    public ColumnHelper(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet)

Method Detail

### cleanColumns

    public void cleanColumns()

### sortColumns

    public static void sortColumns(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols newCols)

### cloneCol

    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)

### getColumn

    public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol getColumn(long index,
                                                                               boolean splitColumns)

  Returns the Column at the given 0 based index

### getColumn1Based

    public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol getColumn1Based(long index1,
                                                                                     boolean splitColumns)

  Returns the Column at the given 1 based index. POI default is 0 based, but the file stores as 1 based.

### addCleanColIntoCols

    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)

### columnExists

    public 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?

### setColumnAttributes

    public void setColumnAttributes(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol fromCol,
                                    org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol toCol)

### setColBestFit

    public void setColBestFit(long index,
                              boolean bestFit)

### setCustomWidth

    public void setCustomWidth(long index,
                               boolean bestFit)

### setColWidth

    public void setColWidth(long index,
                            double width)

### setColHidden

    public void setColHidden(long index,
                             boolean hidden)

### setColDefaultStyle

    public void setColDefaultStyle(long index,
                                   org.apache.poi.ss.usermodel.CellStyle style)

### setColDefaultStyle

    public void setColDefaultStyle(long index,
                                   int styleId)

### getColDefaultStyle

    public int getColDefaultStyle(long index)

### getIndexOfColumn

    public int getIndexOfColumn(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols cols,
                                org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol col)

### getColumnWidth

    public static double getColumnWidth(XSSFSheet sheet,
                                        int column,
                                        boolean useMergedCells)

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD