> For the complete documentation index, see [llms.txt](https://astro-rpa.gitbook.io/astro-rpa-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://astro-rpa.gitbook.io/astro-rpa-user-guide/g_elements/el_basic/gsheets/el_gsheets_readrange.md).

# Read range

Component getting data from the Google Sheets cell range. The component works correctly only inside the Excel application container

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-66767545c99bc1460c969049d2fa95672a6dacb2%2Fimage%20\(246\).png?alt=media)

Properties

* Range: \[String] Cell reader range (A1:D12). If nothong is specified, current selection will be used as range
* Sheet name: \[String] Sheet name
* Variable (text): \[List>] Variable for storing reading results
* Variable (info): \[List>] Variable for storing reading results with cell info
* Variable (table): \[System.Data.DataTable] Variable for storing reading results
* Headers row: First row contains headers (for table)

LTools.Office.Model.ExcelCellInfo - Properties:

* Value: \[LTools.Office.Model.CellValue] Cell value
* TextValue: \[String] Cell text value
* BackroundColor: \[System.Drawing.Color] Cell background color
* FontColor: \[System.Drawing.Color] Cell font color
* BorderType: \[LTools.Office.Model.ExcelBorderTypes?] Cell border type
* CustomBorderType: \[LTools.Office.Model.ExcelCustomBorderTypes\[]] Cell border type for ExcelBorderTypes.Custom
* Height: \[double?] Row height (determined by first cell)