...
Code Block | ||||
---|---|---|---|---|
| ||||
{ "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.
...