I'm attempting to iterate through the rows of each sheet in an opened Excel sheet - I'm replacing code that used the GemBox library. Previously, I used code like the following:
foreach
(ExcelRow row
in
sheet.Rows)
{
if
(row !=
null
)
{
...
do
stuff ....
}
}
Is the following the best conversion to using the Telerik library? Or is there a better way to only iterate through rows with content?
for (int i = 0; i < sheet.Rows.Count; i++)
{
var row = sheet.Cells[CellRange.FromRow(i)];
if (row != null)
{
... do stuff ....
}
}