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 one 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
endRow	Ends reading when the excel row no is greater then given endRow value	Number. Optional. Will read until the end of the row if endRow is not given
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. if a column name is not defined as product element, that column will be skipped from reading	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
toClipBoard	Copy's data to system clip board	Boolean. True/ False Default is false
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