# Excel: Read data from excel

| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | <p>Number. Optional. </p><p>Will read until the end of the row if endRow is not given</p> |
| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | <p>Boolean. True/ False </p><p>Default is false</p>                                       |
| adjustColumnData.batch\[Number]:\[columnName] Column procesing is done based on batch no sequence | <p>1) Converting String with delimiter to QStringArray</p><p>Expression to use:</p><p><strong>convertTo</strong>:delimiter.\[Delimiter String/Char]:<strong>dest</strong>.\[Dest Element Name]</p><p>Predefined Delimiters: </p><p><code>comma</code></p><p><code>dot</code></p><p><code>hash</code></p><p><code>hyphen</code></p><p>Custom Delimiter: must be defined in square brackets. Some examples:</p><p><strong>delimiter.\[and]</strong> word and is delimiter</p><p><strong>delimiter.\[break by]</strong> word break by is delimiter</p><p><strong>delimiter.\[']</strong> character single quote is delimiter</p><p></p><p></p><p>2) Moving Another column data as child object</p><p>Expression to use:</p><p><strong>moveAsChild</strong>:keyName.\[Child Column Name]:keyValue.\[Child Column Data]</p> | Optional. Define for columns that need adjustment                                         |