My Excel file is not in tabular data. I am trying to read from an excel file.
I have sections within my excel file that are tabular.
I need to loop through rows 3 to 20 which are tabular and read the data.
Here is party of my code:
```
string fileName = "C:\\Folder1\\Prev.xlsx";
var workbook = new XLWorkbook(fileName);
var ws1 = workbook.Worksheet(1);
```
How do I loop through rows 3 to 20 and read columns 3,4, 6, 7, 8?
Also if a row is empty, how do I determine that so I can skip over it without reading that each column has a value for a given row.
Reading from Excel Fichier using FermerdXML
Re: Reading from Excel Fichier using FermerdXML
To access a row:
```
var row = ws1.Row(3);
```
To check if the row is empty:
```
bool empty = row.IsEmpty();
```
To access a cell (column) in a row:
```
var cell = row.Cell(3);
```
To get the value from a cell:
```
object value = cell.Value;
// or
string value = cell.GetValue();
```
For more information see the [documentation](https://github.com/closedxml/closedxml/wiki/Cell-Values).
```
var row = ws1.Row(3);
```
To check if the row is empty:
```
bool empty = row.IsEmpty();
```
To access a cell (column) in a row:
```
var cell = row.Cell(3);
```
To get the value from a cell:
```
object value = cell.Value;
// or
string value = cell.GetValue
```
For more information see the [documentation](https://github.com/closedxml/closedxml/wiki/Cell-Values).