HSSFWorkbook2DBProcessor

de.isdss.util.processors.HSSFWorkbook2DBProcessor

Top  Previous  Next

Parameter

class = de.isdss.util.processors.HSSFWorkbook2DBProcessor

 

This processor reads an XLS document into a HSSF workbook object.

Example configuration:  XLSdata  jdbc:hsqldb:mem:test  org.hsqldb.jdbcDrive  sa  initial//optional someKey

 

Parameter

 Description

jdbc.connectionpool

name of the connectionpool - if exisiting in Pipeline url and driver are ignored

jdbc.driver

(optional) JDBC driver used for the communication to the database.

Default: org.hsqldb.jdbcDriver

jdbc.url        

(optional)URL for the given JDBC driver.

Default: jdbc:hsqldb:mem

resultParamKey

Output parameter key where the connection is stored in

readsheet

(optional) default to initial

 

"readFile" can be a filename or a parameter containing a filename. Note: The value of "readFile" may not be "readFile"! "readSheet" can be a sheetname or excel jump marker (f.e. "data1!A1" for sheet "data1", column "A", row "1"), it's only "data1" used to open the sheet, the rest is ignored

 

 

HssfWorkbookProcesor