# Read Excel

This adds the first worksheet to an ExcelWorksheet variable, creates a loop based on the number of written rows in the excel document, getting the values and adding them to a list (List\<string> in the snipped below) with each iteration.

This script will require adding **using OfficeOpenXml;** to the namespaces section.

```csharp
ExcelWorksheet document = excelDocument.getWorkSheet(1);
int RowsCount = document.Dimension.End.Row; 

for (int j=1;j<=RowsCount;j++)
{
    string cellValue = document.Cells[j, 1].GetValue<string>();					          List<string>.Add(cellValue);}
    List<string>.Add(cellValue);
}
```

{% hint style="info" %}
The ExcelWorksheet variable has to be open using the “Open excel workbook” action before initializing the C# script, otherwise it will not be a valid reference to an Excel Workbook.
{% endhint %}