com.jidesoft.hssf

Class CsvPivotTableUtils

java.lang.Object

com.jidesoft.hssf.CsvPivotTableUtils

Deprecated.

replaced by CsvPivotTableUtils to remove the dependency on POI jars

@Deprecated
public class CsvPivotTableUtils
extends Object

CsvPivotTableUtils is a class that has methods to export PivotTablePane'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/columns because of the CSV format limitation.

Constructor Summary

Constructors

Constructor and Description
CsvPivotTableUtils() Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
static boolean	export(PivotTablePane pivotTablePane, OutputStream out) Deprecated. Exports the pivotTablePane to as CSV file output steam.
static boolean	export(PivotTablePane pivotTablePane, OutputStream out, HssfTableUtils.CellValueConverter cellValueConverter) Deprecated. Exports the pivotTablePane to as CSV file output steam.
static boolean	export(PivotTablePane pivotTablePane, OutputStream out, HssfTableUtils.CellValueConverter cellValueConverter, char separator) Deprecated. Exports the pivotTablePane to as CSV file output steam.
static boolean	export(PivotTablePane pivotTablePane, String fileName) Deprecated. Exports the pivotTablePane to an CSV file.
static boolean	export(PivotTablePane pivotTablePane, String fileName, HssfTableUtils.CellValueConverter cellValueConverter) Deprecated. Exports the pivotTablePane to an CSV file.
static boolean	export(PivotTablePane pivotTablePane, String fileName, HssfTableUtils.CellValueConverter cellValueConverter, char separator) Deprecated. Exports the pivotTablePane to an CSV file.

Methods inherited from class java.lang.Object

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

Constructor Detail

CsvPivotTableUtils

public CsvPivotTableUtils()

Deprecated.

Method Detail

export

public static boolean export(PivotTablePane pivotTablePane,
             String fileName)
                      throws IOException

Deprecated.

Exports the pivotTablePane to an CSV file.

Parameters:

pivotTablePane - the pivotTablePane 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(PivotTablePane pivotTablePane,
             String fileName,
             HssfTableUtils.CellValueConverter cellValueConverter)
                      throws IOException

Deprecated.

Exports the pivotTablePane to an CSV file.

Parameters:

pivotTablePane - the pivotTablePane to be exported.

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

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(PivotTablePane pivotTablePane,
             String fileName,
             HssfTableUtils.CellValueConverter cellValueConverter,
             char separator)
                      throws IOException

Deprecated.

Exports the pivotTablePane to an CSV file.

Parameters:

pivotTablePane - the pivotTablePane to be exported.

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

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

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(PivotTablePane pivotTablePane,
             OutputStream out)
                      throws IOException

Deprecated.

Exports the pivotTablePane to as CSV file output steam.

Parameters:

pivotTablePane - the pivotTablePane 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(PivotTablePane pivotTablePane,
             OutputStream out,
             HssfTableUtils.CellValueConverter cellValueConverter)
                      throws IOException

Deprecated.

Exports the pivotTablePane to as CSV file output steam.

Parameters:

pivotTablePane - the pivotTablePane to be exported.

out - the output stream

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(PivotTablePane pivotTablePane,
             OutputStream out,
             HssfTableUtils.CellValueConverter cellValueConverter,
             char separator)
                      throws IOException

Deprecated.

Exports the pivotTablePane to as CSV file output steam.

Parameters:

pivotTablePane - the pivotTablePane to be exported.

out - the output stream

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

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