Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejs
linenumberstrue
{
   "name": "ExcelInputReader",
   "type": "batchsource",
   "properties": {
            "filesPathfilePath": "file:///hadoop/hdfs/xyz.xls",
		"filesPatternhome/cdap",
        "filePattern": ".*",
            "memoryTableName": "inventory-memory-table",
            "reprocess": "false",
            "sheetName": "memory-tableSheet1",
            "sheetNo": "2-1",
		
        "columnList": "A,B",
        "columnMapping": "B:name,C:age",
            "skipFirstColumnskipFirstRow": "false",
            "terminateIfEmptyRow": "false",
            "rowsLimit": "2000" ,
            "outputSchema": "column1:dataType1,column2:dataType2A:string",
            "ifErrorRecord" : "datasetIgnore error and continue",
            "errorDatasetName": "error-dataset"
     } 
}

Analyzing https://poi.apache.org/spreadsheet/index.html library to implement plug-in.

...