Package ca.spatial.table

Class TableSpec.ExcelSpec

java.lang.Object

ca.spatial.table.TableSpec

ca.spatial.table.TableSpec.ExcelSpec

Enclosing class:

TableSpec

public static class TableSpec.ExcelSpec
extends TableSpec

This specification will describe an ExcelStore table.

The syntax for this specification is

 Excel {workbook} {sheetname} {skip=n}?
 

Nested Class Summary

Nested classes/interfaces inherited from class ca.spatial.table.TableSpec

TableSpec.AppendSpec, TableSpec.CoverageSpec, TableSpec.CrosstabSpec, TableSpec.CSVSpec, TableSpec.DBaseSpec, TableSpec.ExcelSpec, TableSpec.FlattenSpec, TableSpec.InfoSpec, TableSpec.JDBCSpec, TableSpec.RamAttributeStoreSpec, TableSpec.RelationSpec, TableSpec.ShapefileSpec, TableSpec.SnapshotSpec, TableSpec.SummarySpec, TableSpec.TransposePeriodSpec, TableSpec.TransposeRowSpec, TableSpec.TransposeSpec, TableSpec.VirtualSpec

Constructor Summary

Constructors

Constructor	Description
ExcelSpec(String workbook, String worksheet, int skipRows)	Create an Excel TableSpec object

Method Summary

Modifier and Type	Method	Description
String	getCanonicalName()	Get the unique and unequivocal identifier for this TableSpec.
String	getFlavour()	Get the type of table described by this TableSpec.
String	getTableName()	Get the name of the table described by this TableSpec.
AttributeStore	open()	Open the data table described by this TableSpec.

Methods inherited from class ca.spatial.table.TableSpec

decode, equals, isDefaultEncoding, isGeoRelational, isPlain, open, open, quoteExprIfRequired, quoteIfRequired, toString

Methods inherited from class java.lang.Object

getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

ExcelSpec

public ExcelSpec(String workbook,
 String worksheet,
 int skipRows)

Create an Excel TableSpec object

Parameters:

workbook - the file path to the workbook

worksheet - the name of the worksheet

skipRows - the number of row at the top of the worksheet to skip before coming to the column heading row.

Method Details

getFlavour

public String getFlavour()

Description copied from class: TableSpec

Get the type of table described by this TableSpec.

Specified by:

getFlavour in class TableSpec

getTableName

public String getTableName()

Description copied from class: TableSpec

Get the name of the table described by this TableSpec.

Specified by:

getTableName in class TableSpec

getCanonicalName

public String getCanonicalName()

Description copied from class: TableSpec

Get the unique and unequivocal identifier for this TableSpec.

Overrides:

getCanonicalName in class TableSpec

open

public AttributeStore open()
                    throws Exception

Description copied from class: TableSpec

Open the data table described by this TableSpec.

Specified by:

open in class TableSpec

Throws:

Exception