Iterating through rows of a sheet

[Rob]

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 ....
   }
}

[Rob]

I actually just found a post here that shows how to identify which cells are used or not, which is what I was looking for.

[Tanya]

Hello Rob,

Indeed, the UsedCellRange property should help you implement the desired behavior. Please, note that the UsedCellRange property returns all the cells that have applied any property on them. With the GetUsedCellRange() method though you can obtain those cells that have a specific property set. You can read more and check how to use both members in the documentation article.

Hope this helps.

Regards,
Tanya
Progress Telerik