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
