com.jidesoft.grid

Class CsvTableUtils

java.lang.Object

com.jidesoft.grid.CsvTableUtils

public class CsvTableUtils
extends Object

CsvTableUtils is a class that has methods to export any JTable'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.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CsvTableUtils.CsvTableExportConfig A class that has all the parameters that could be customized when exporting a table or a TableScrollPane to csv file.

Constructor Summary

Constructors

Constructor and Description
CsvTableUtils()

Method Summary

Methods

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

Methods inherited from class java.lang.Object

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

Constructor Detail

CsvTableUtils

public CsvTableUtils()

Method Detail

export

public static boolean export(JTable table,
             String fileName)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table 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(JTable table,
             String fileName,
             boolean includeTableHeader)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table to be exported.

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

includeTableHeader - whether to include the table 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(JTable table,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table to be exported.

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

includeTableHeader - whether to include the table 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(JTable table,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table to be exported.

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

includeTableHeader - whether to include the table 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(JTable table,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table 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 table 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(JTable table,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             String fileName,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter,
             char separator)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table 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 table 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(JTable table,
             String fileName,
             CsvTableUtils.CsvTableExportConfig config)
                      throws IOException

Exports the table to an CSV file.

Parameters:

table - the table to be exported.

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

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

addCellValue

public static void addCellValue(StringBuffer csvBuffer,
                String cellValue,
                char separator)

addLineBreak

public static void addLineBreak(StringBuffer csvBuffer)

export

public static boolean export(JTable table,
             OutputStream out)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table 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(JTable table,
             OutputStream out,
             boolean includeTableHeader)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table to be exported.

out - the output stream

includeTableHeader - whether to include the table 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(JTable table,
             OutputStream out,
             boolean includeTableHeader,
             ValueConverter cellValueConverter)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table to be exported.

out - the output stream

includeTableHeader - whether to include the table 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(JTable table,
             OutputStream out,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table to be exported.

out - the output stream

includeTableHeader - whether to include the table 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(JTable table,
             OutputStream out,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table 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 table 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(JTable table,
             OutputStream out,
             int firstRow,
             int firstColumn,
             int numberOfRows,
             int numberOfColumns,
             boolean includeTableHeader,
             ValueConverter cellValueConverter,
             StringConverter columnNameConverter,
             char separator)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table 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 table 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(JTable table,
             OutputStream out,
             CsvTableUtils.CsvTableExportConfig config)
                      throws IOException

Exports the table to a CSV file output steam.

Parameters:

table - the table 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