> For the complete documentation index, see [llms.txt](https://docs.qatts.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.qatts.com/master-1/smarties/excel-read-data-from-excel.md).
# 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 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 |