Excel: Read data from excel

Reads data from an excel sheet and gives output as QArray or QData based on config

Param Name	Param Desc	Default Value
fileName	Location & Name of the file	Assume that file is in the Agent Data Folder
sheetName	Excel Sheet from which data must be read	Mandatory Field
dataElementName	Name of the Product Element defining the data structure	Valid Prodcut Element with data type QData
dataType	Represent the type of data that you are reading. Select on of the options. [multiRow, keyValue]	No Default
firstRow	Starting row from where the data must be read. For example if the data start from first row, give 1. Remember to match with the row no in excel	1
firstColumn	Starting column from where the data must be read. For example, if the data start from column A, give 1	1
firstRowHasColumnHeaders	When true smarty will read column names from the first row of the excel. All the column names must be defined a product elements. When false, it will take column names from the columnNames property	false
columnNames	Column name will be mapped to the product elements. Specify column names separated with comma	No default
keyColumnName	Specify keyColumnName if data is represented with single field. This is very helpful when doing find on the row on QArray
adjustColumnData.batch[Number]:[columnName] Column procesing is done based on batch no sequence	1) Converting String with delimiter to QStringArray Expression to use: convertTo:delimiter.[Delimiter String/Char]:dest.[Dest Element Name] Predefined Delimiters: comma dot hash hyphen Custom Delimiter: must be defined in square brackets. Some examples: delimiter.[and] word and is delimiter delimiter.[break by] word break by is delimiter delimiter.['] character single quote is delimiter 2) Moving Another column data as child object Expression to use: moveAsChild:keyName.[Child Column Name]:keyValue.[Child Column Data]	Optional. Define for columns that need adjustment