com.jidesoft.grid

Class CsvTableScrollPaneUtils

java.lang.Object

com.jidesoft.grid.CsvTableScrollPaneUtils

public class CsvTableScrollPaneUtils
extends Object

CsvTableScrollPaneUtils is a class that has methods to export TableScrollPane's content to Character Separated Values file format.

The export feature will not consider the cell contents conversion but you can use ValueConverter to format the value if you want. It will also optionally consider table header as part of the export. You could also choose any character including comma as the separator.

It does NOT support cell span and will LOSE the collapsed rows in TreeTable scenario because of the CSV format limitation.

Constructor Summary

Constructors

Constructor and Description
CsvTableScrollPaneUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static boolean	export(TableScrollPane scrollPane, int firstRow, int firstColumn, int numberOfRows, int numberOfColumns, String fileName, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter) Exports the scrollPane to an CSV file.
static boolean	export(TableScrollPane scrollPane, int firstRow, int firstColumn, int numberOfRows, int numberOfColumns, String fileName, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter, char separator) Exports the scrollPane to an CSV file.
static boolean	export(TableScrollPane scrollPane, OutputStream out) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, boolean includeTableHeader) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, boolean includeTableHeader, ValueConverter cellValueConverter) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, CsvTableUtils.CsvTableExportConfig config) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, int firstRow, int firstColumn, int numberOfRows, int numberOfColumns, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, OutputStream out, int firstRow, int firstColumn, int numberOfRows, int numberOfColumns, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter, char separator) Exports the scrollPane to a CSV file output steam.
static boolean	export(TableScrollPane scrollPane, String fileName) Exports the TableScrollPane to an CSV file.
static boolean	export(TableScrollPane scrollPane, String fileName, boolean includeTableHeader) Exports the scrollPane to an CSV file.
static boolean	export(TableScrollPane scrollPane, String fileName, boolean includeTableHeader, ValueConverter cellValueConverter) Exports the scrollPane to an CSV file.
static boolean	export(TableScrollPane scrollPane, String fileName, boolean includeTableHeader, ValueConverter cellValueConverter, StringConverter columnNameConverter) Exports the scrollPane to an CSV file.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CsvTableScrollPaneUtils

public CsvTableScrollPaneUtils()

Method Detail

export

public static boolean export(TableScrollPane scrollPane,
             String fileName)
                      throws IOException

Exports the TableScrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

fileName - the CSV file name. It should be the full path to the file.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             String fileName,
             boolean includeTableHeader)
                      throws IOException

Exports the scrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

fileName - the CSV file name. It should be the full path to the file.

includeTableHeader - whether to include the scrollPane header.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter)
                      throws IOException

Exports the scrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

fileName - the CSV file name. It should be the full path to the file.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the scrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

fileName - the CSV file name. It should be the full path to the file.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the scrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

firstRow - the first row to be exported

firstColumn - the first row to be exported

numberOfRows - number of rows to be exported, -1 means all rows.

numberOfColumns - number of columns to be exported. -1 means all columns.

fileName - the CSV file name. It should be the full path to the file.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter,
             char separator)
                      throws IOException

Exports the scrollPane to an CSV file.

Parameters:

scrollPane - the scrollPane to be exported.

firstRow - the first row to be exported

firstColumn - the first row to be exported

numberOfRows - number of rows to be exported, -1 means all rows.

numberOfColumns - number of columns to be exported. -1 means all columns.

fileName - the CSV file name. It should be the full path to the file.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

separator - the character used to separate the cells. By default, it is a comma.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             boolean includeTableHeader)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

includeTableHeader - whether to include the scrollPane header.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             boolean includeTableHeader,
             ValueConverter cellValueConverter)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

firstRow - the first row to be exported

firstColumn - the first row to be exported

numberOfRows - number of rows to be exported, -1 means all rows.

numberOfColumns - number of columns to be exported. -1 means all columns.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter,
             char separator)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

firstRow - the first row to be exported

firstColumn - the first row to be exported

numberOfRows - number of rows to be exported, -1 means all rows.

numberOfColumns - number of columns to be exported. -1 means all columns.

includeTableHeader - whether to include the scrollPane header.

cellValueConverter - the converter to convert cell value to the value that can be set to CSV cell.

columnNameConverter - the converter to convert the column name.

separator - the character used to separate the cells. By default, it is a comma.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

export

public static boolean export(TableScrollPane scrollPane,
             OutputStream out,
             CsvTableUtils.CsvTableExportConfig config)
                      throws IOException

Exports the scrollPane to a CSV file output steam.

Parameters:

scrollPane - the scrollPane to be exported.

out - the output stream

config - a collection of the parameters that could be configured during the export process.

Returns:

true if exporting succeed. If poi.jar is not in the classpath, false will be returned. Exception will be thrown if there is error during the exporting.

Throws:

IOException - if the write to the file failed.

FileNotFoundException - if the file exists but is a directory rather than a regular file, does not exist but cannot be created, or cannot be opened for any other reason

Since:

3.3.8