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: 1.6 $

Author:

Manuel Laflamme

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)
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

cloneTables, getTable, getTableMetaData, getTableNames, getTables, 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.

XlsDataSet

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

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

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

Specified by:

createIterator in class AbstractDataSet

Throws:

DataSetException