# Excel Reader

This component reads data from an Excel file and makes it available for further processing in the integration process.&#x20;

![](https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image277.png)

This component can load data from both .xls and .xlsx Excel files. While loading data from the Excel file, the memory footprint can be an issue. The Reader component loads the data into memory and parse the data. If the size of the Excel file is bigger than 10MB, the Reader component tries to load data through streaming instead. Streaming is reading line by line and parsing to the end of the sheet. This streaming can reduce the memory usage of the execution.&#x20;

This streaming supports .xlsx files because .xlsx is a compressed XML file.

## **Input**

&#x20;

<table><thead><tr><th width="221">Attribute</th><th>Description</th></tr></thead><tbody><tr><td>Input File Path</td><td>The full path of the input file</td></tr><tr><td>Password</td><td>Password to read the excel file, if exists.</td></tr><tr><td>Sheet Name</td><td><p>Sheet name to load.</p><p>If sheet name is empty, all the sheets are loaded.</p></td></tr><tr><td>Header Exists?</td><td><p>Does header row exist?</p><p>If yes, the first row is treated as header.</p><p>The first row means the first row which have data.</p></td></tr><tr><td>Starting Row</td><td><p>Row number starts from 0.</p><p>If starting row is 0 and header exists, the data row starts from the second row(1). </p></td></tr><tr><td>Null Indicator</td><td><p>Null indicator value, if exists.</p><p>If the value of a cell is as same as this value, that value is converted to null.</p></td></tr><tr><td>Date Format</td><td>If date format is set, the value of date type cell is converted into string with date format.</td></tr></tbody></table>

&#x20;

&#x20;

## **Output**

&#x20;

<table><thead><tr><th width="217">Attribute</th><th>Description</th></tr></thead><tbody><tr><td>ExcelResultArray</td><td>Excel data</td></tr><tr><td>ExcelResultCount</td><td><p>Record count</p><p>If SheetName is not specified, the record counts of the all the sheets are created with the name of the sheets as suffix like this.</p><p>ExcelResultCount-Sheet1 : 10</p><p>ExcelResultCount-Sheet2 : 20</p></td></tr><tr><td>DataStructureId</td><td>Data structure id for mapping</td></tr></tbody></table>
