org.autoplot.excel

Class ExcelSpreadsheetDataSource

java.lang.Object

org.autoplot.datasource.AbstractDataSource

org.autoplot.excel.ExcelSpreadsheetDataSource

All Implemented Interfaces:

DataSource

public class ExcelSpreadsheetDataSource
extends AbstractDataSource

Creates QDataSets from an Excel spreadsheet using Apache POI library.

• http://www.autoplot.org/data/swe-np.xls?column=data&depend0=dep0
• http://sarahandjeremy.net/~jbf/autoplot/data/hudson_data/xls/2008-lion and tiger summary.xls?sheet=Samantha+tiger+lp+lofreq&firstRow=53&column=Complex_Modulus&depend0=Frequency
• http://www.icip.iastate.edu/sites/default/files/uploads/tables/agriculture/ag-land-hist.xls?column=C14:BM14
• file:///home/jbf/ct/hudson/data/xls/c2-70landvalues.xls?sheet=County&column=BM&depend0=A

Field Summary

Fields inherited from class org.autoplot.datasource.AbstractDataSource

params, resourceURI, uri

Constructor Summary

Constructors

Constructor and Description
ExcelSpreadsheetDataSource(java.net.URI uri) Creates a new instance of ExcelSpreadsheetDataSource.

Method Summary

Modifier and Type	Method and Description
protected static int	findFirstRow(HSSFSheet sheet, int firstRow)
QDataSet	getDataSet(ProgressMonitor mon) retrieve the dataset.

Methods inherited from class org.autoplot.datasource.AbstractDataSource

addCability, addCapability, asynchronousLoad, doWhereFilter, getCapability, getExt, getExt, getFile, getFile, getFile, getHtmlFile, getInputStream, getMetadata, getMetadataModel, getParam, getParams, getProperties, getURI, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelSpreadsheetDataSource

public ExcelSpreadsheetDataSource(java.net.URI uri)
                           throws java.io.IOException

Creates a new instance of ExcelSpreadsheetDataSource. file://c:/myfile.xls?column=N&depend0=G parameters: column=id the column ID for the data depend0=id the column ID for the x tags file://C:/iowaCitySales2004-2006.latlong.xls?column=M[2:]&depend0=B[2:]&plane0=C[2:]

Parameters:

uri -

Throws:

java.io.IOException

Method Detail

getDataSet

public QDataSet getDataSet(ProgressMonitor mon)
                    throws java.io.IOException

Description copied from interface: DataSource

retrieve the dataset. This allowed to be sub-interactive or batch time scale, and will block until the dataset is produced. This may return null when no data is available, or NoDataInIntervalException can be thrown. If the user cancelled the operation, then java.io.InterrupedIOExcaption or better yet org.das2.CancelledOperationException should be called. These will simply display "cancelled" (or similar) on the status bar.

Specified by:

getDataSet in interface DataSource

Specified by:

getDataSet in class AbstractDataSource

Returns:

the DataSet for the URI, or null if no data is available.

Throws:

java.io.IOException

findFirstRow

protected static int findFirstRow(HSSFSheet sheet,
                                  int firstRow)