Hide a column while exporting to a Excel

[dvraghu]

Hi,

I would like to hide a column in the SortableTable, before exporting it to the excel. Currently in the sortable table demo also, we export the icon column by using

Code: Select all

  HssfTableUtils.export(_sortableTable, chooser.getSelectedFile().getAbsolutePath(), "SortableTable", false, true, new HssfTableUtils.DefaultCellValueConverter()


Can you please let me know such an option is possible?

Regards,
dvraghu

[JIDE Support]

Is it possible for you to do a combination while exporting to excel? Please be noted that the "4" should be the model index of the column you wish to hide.

Code: Select all

                        TableColumnChooser.hideColumn(_sortableTable, 4);
                        HssfTableUtils.export(_sortableTable, chooser.getSelectedFile().getAbsolutePath(), "SortableTable", false, true, new HssfTableUtils.DefaultCellValueConverter() {
                        //....
                        });
                        TableColumnChooser.showColumn(_sortableTable, 4, -1);


Thanks,

[dvraghu]

Hi Support Team,

Thanks for the very quick reply. Actually I could able to find this workaround myself.
Never expected such a prompt and useful reply in a quick time.
JIDE Rocks

Regards,
dvraghu