/** * this method update column header of sheet into table * * @param ctTable * xssf table object * @param title * title of column * @param index * index of column */ private void updateSheetTable(CTTable ctTable, String title, int index) { CTTableColumns tableColumnList = ctTable.getTableColumns(); CTTableColumn column = null; for( int i = 0; tableColumnList.getCount() < index; i++) { column = tableColumnList.addNewTableColumn(); column.setId(i); } column = tableColumnList.getTableColumnArray(index); column.setName(title); }
CTTableColumns ctColumns = ctTable.addNewTableColumns(); CTAutoFilter autofilter = ctTable.addNewAutoFilter(); ctColumns.setCount(table_headers.size()); for(int i = 0; i < table_headers.size(); i++) { CTTableColumn column = ctColumns.addNewTableColumn(); column.setName(table_headers.get(i)); column.setId(i + 1); CTFilterColumn filter = autofilter.addNewFilterColumn(); filter.setColId(i + 1); filter.setShowButton(true); }
/** * this method update column header of sheet into table * * @param ctTable * xssf table object * @param title * title of column * @param index * index of column */ private void updateSheetTable(CTTable ctTable, String title, int index) { CTTableColumns tableColumnList = ctTable.getTableColumns(); CTTableColumn column = null; for( int i = 0; tableColumnList.getCount() < index; i++) { column = tableColumnList.addNewTableColumn(); column.setId(i); } column = tableColumnList.getTableColumnArray(index); column.setName(title); }
CTTableColumn column = columns.addNewTableColumn(); column.setName("Column" + i); column.setId(i+1);
CTTableColumn column = ctColumns.addNewTableColumn(); column.setName(tableHeaders.get(i)); column.setId(i + 1);
CTTableColumn column = columns.addNewTableColumn(); column.setId(++i); column.setName(colName);
CTTableColumn column = columns.addNewTableColumn(); column.setName("Column" + i);