org.dbunit.dataset.excel
Class XlsDataSet

java.lang.Object
  org.dbunit.dataset.AbstractDataSet
      org.dbunit.dataset.excel.XlsDataSet

All Implemented Interfaces:

IDataSet

public class XlsDataSet
extends AbstractDataSet

This dataset implementation can read and write MS Excel documents. Each sheet represents a table. The first row of a sheet defines the columns names and remaining rows contains the data.

Since:

Feb 21, 2003

Version:

$Revision: 875 $

Author:

Manuel Laflamme

Field Summary

Fields inherited from class org.dbunit.dataset.AbstractDataSet

_orderedTableNameMap

Constructor Summary

XlsDataSet(java.io.File file)
Creates a new XlsDataSet object that loads the specified Excel document.

XlsDataSet(java.io.InputStream in)
Creates a new XlsDataSet object that loads the specified Excel document.

Method Summary

protected ITableIterator	createIterator(boolean reversed) Creates an iterator which provides access to all tables of this dataset
static void	write(IDataSet dataSet, java.io.OutputStream out) Write the specified dataset to the specified Excel document.

Methods inherited from class org.dbunit.dataset.AbstractDataSet

createTableNameMap, getTable, getTableMetaData, getTableNames, getTables, isCaseSensitiveTableNames, iterator, reverseIterator, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

XlsDataSet

public XlsDataSet(java.io.File file)
           throws java.io.IOException,
                  DataSetException

Creates a new XlsDataSet object that loads the specified Excel document.

Throws:

java.io.IOException

DataSetException

XlsDataSet

public XlsDataSet(java.io.InputStream in)
           throws java.io.IOException,
                  DataSetException

Creates a new XlsDataSet object that loads the specified Excel document.

Throws:

java.io.IOException

DataSetException

Method Detail

write

public static void write(IDataSet dataSet,
                         java.io.OutputStream out)
                  throws java.io.IOException,
                         DataSetException

Write the specified dataset to the specified Excel document.

Throws:

java.io.IOException

DataSetException

createIterator

protected ITableIterator createIterator(boolean reversed)
                                 throws DataSetException

Description copied from class: AbstractDataSet

Creates an iterator which provides access to all tables of this dataset

Specified by:

createIterator in class AbstractDataSet

Parameters:

reversed - Whether the created iterator should be a reversed one or not

Returns:

The created ITableIterator

Throws:

DataSetException