org.dbunit.dataset.excel
Class XlsDataSet

java.lang.Object
  extended by org.dbunit.dataset.AbstractDataSet
      extended by 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

Constructor Summary
XlsDataSet(File file)
          Creates a new XlsDataSet object that loads the specified Excel document.
XlsDataSet(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, 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(File file)
           throws IOException,
                  DataSetException
Creates a new XlsDataSet object that loads the specified Excel document.

Throws:
IOException
DataSetException

XlsDataSet

public XlsDataSet(InputStream in)
           throws IOException,
                  DataSetException
Creates a new XlsDataSet object that loads the specified Excel document.

Throws:
IOException
DataSetException
Method Detail

write

public static void write(IDataSet dataSet,
                         OutputStream out)
                  throws IOException,
                         DataSetException
Write the specified dataset to the specified Excel document.

Throws:
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


Copyright © 2002-2012. All Rights Reserved.