![]() |
Consumption Analytics Documentation |
The SmartExcelCollector
works in conjunction with the SpreadSheetFeedConfig bean that is used to describe how the rows and columns of data are to be interpreted.
Data is generally processed column by column. For example, one column might be defined as containing identifiers, another column might be defined as containing resource quantities, and a third column might be defined as containing the usage date.
In summary, columns can contain the following data types:
The feed configuration is responsible for describing the input of the XLS file. In general, rows from the file are transferred to CC Record files.
An Excel spreadsheet feed can be any data contained in a spreadsheet document. You can map a set of columns from a single worksheet to an output CC Record file for processing. Within the feed configuration area, you describe what columns and time and date, identifiers, and resources.
If the Excel file contains a header row, the OutputField
can reference a value from the header row as .input
. Otherwise, InputField
objects can be used to name the input columns for mapping to output. Another option to name identifiers and resources when no header exists is to set the input property of OutputField
to a column number, and set the label property to a name or labelInput
property to a column number.
Column numbers begin at 1 and the first column is not always equivalent to column 'A'. Empty columns before or after data in the spreadsheet are ignored. Empty rows before or after data in the sheet are also ignored. This should be taken into account when specifying input column numbers or setting a value for the SpreadSheetFeedConfig
’s linesToSkip
property. Blank rows in the middle of the data set can cause processing errors.
Columns in the Excel file can contain time and date data types. The following shows an example of the types of usage that can be output and mapped.
Columns in the Excel file contain identifier and resource data types. The following shows an example of the types of data can be output and mapped.
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP