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.

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);}

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.

Last updated