ExcelInputFormat is used to read Microsoft Excel file formats (such as .xls and .xlsx) as input data.

Configuration

Configuration names consist of the following parameters:

• hgrid247.excel.sheet2process
  Indicates which sheet will be processed.
  • Default value: the first sheet
  • To process all sheets, set the value to "all".
• hgrid247.excel.columndelimiter
  Indicates the column delimiter used in the output.
  Default value: comma (,).
• solusi247.excel.includeSheetName
  Indicates whether the sheet name should be included in the output.
  • If enabled, the sheet name is prefixed to the data.
  • The delimiter between the sheet name and the data is #.
  • Default value: not included.

Behavior

• Reads Excel files row by row
• Converts each row into a single output record
• Columns are separated using the configured column delimiter
• Optionally prefixes each record with the sheet name

Typical Use Cases

• ETL processing of Excel files
• Ingesting multi-sheet Excel workbooks
• Converting spreadsheet data into delimited text for downstream processing