excelFileDS

Using the excelFileDS Data Source

Purpose

The aim of this Data Source is to read or write into a Excel file (currently this DataSource is read-only).

Configuration

The specific configuration (as a Datasource) in the configuration file section parameters includes the following parameters:

• sheet: By defaults taks the first sheet, otherwise takes the sheet name
• filename: file name (without path)
• path : path of the file to read and/or write

Configuration example:

"classname" : "pipelines.type.directPipeline",
"extractors" : [ {
    "id": "S1",
    "classname": "datasources.excelFileDS",
    "parameters": {
        "sheet": "sheet1",
        "filename": "test.xlsx",
        "path": "tests/data/"
    }   
    ... ] ...