Package mgui.io.domestic.datasources

Class ExportDataTableExcelWriter

java.lang.Object

mgui.io.FileWriter

mgui.io.domestic.datasources.ExportDataTableWriter

mgui.io.domestic.datasources.ExportDataTableExcelWriter

All Implemented Interfaces:

InterfaceIO, IconObject

public class ExportDataTableExcelWriter
extends ExportDataTableWriter

Writes data from a data source DataItem to Microsoft Excel format. Formats include the older XLS and the newer Open Office XML XLSX format.

Depends on the Apache POI Project

Since:

1.0

Version:

1.0

Author:

Andrew Reid

Field Summary

Fields inherited from class mgui.io.FileWriter

dataFile, dataURL, failure_message, options, success_message

Constructor Summary

Constructors

Constructor	Description
ExportDataTableExcelWriter()

Method Summary

Modifier and Type	Method	Description
protected int[]	getCellTypes(java.util.ArrayList<DataField> fields)	Returns the Excel cell type corresponding to each field
boolean	writeDataItem(DataSourceItem item, ProgressUpdater progress_bar)	Writes a DataSourceItem to an external format, using the current settings of this writer.

Methods inherited from class mgui.io.domestic.datasources.ExportDataTableWriter

getStringForValue, write

Methods inherited from class mgui.io.FileWriter

getComplementIOType, getFailureMessage, getFile, getIOType, getLoaderComplement, getObjectIcon, getOptions, getProgressMessage, getSuccessMessage, getSupportedObjects, getTitle, getURL, setFile, setOptions, setURL, toString, write, write

Methods inherited from class java.lang.Object

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

Constructor Details

ExportDataTableExcelWriter

public ExportDataTableExcelWriter()

Method Details

writeDataItem

public boolean writeDataItem(DataSourceItem item,
ProgressUpdater progress_bar)
                      throws java.io.IOException

Description copied from class: ExportDataTableWriter

Writes a DataSourceItem to an external format, using the current settings of this writer.

Specified by:

writeDataItem in class ExportDataTableWriter

Returns:

Throws:

java.io.IOException

getCellTypes

protected int[] getCellTypes(java.util.ArrayList<DataField> fields)

Returns the Excel cell type corresponding to each field

Parameters:

fields -

Returns: