Problem Looping Through Excel Rows with ExcelRW

[David McCarter]

When I downloaded and tested your demo version of ExcelRW this code worked great:

Syncfusion.ExcelRW.IRange usedRows = sheet.Range["MyData"];

foreach (Syncfusion.ExcelRW.IRange row in usedRows.Rows)

{
if (!row.Cells[3].HasNumber)
{
valid = false;
break;
}
}

But now that we purchased a "real" version of ExcelRW, this does not work anymore. This seems to bring back all the values in a column, not a row? When I look at AddressGlobal for the row, it says $A$1:$A$7, when it should be $A$1:$G$1. I am using .NET version 1.1.

David McCarter

[Administrator]

Hi David,

This has been identified as a bug and I have filed a bug report with the development team. You can track the live status of this issue here

http://www.syncfusion.com/support/issues/excelrw/Default.aspx?ToDo=view&questId=347

We will usually get bugs addressed within 2 weeks and a patch release will be available shortly after that.

Thanks,

Stephen.

>When I downloaded and tested your demo version of ExcelRW this code worked great:
>
>Syncfusion.ExcelRW.IRange usedRows = sheet.Range["MyData"];
>
>foreach (Syncfusion.ExcelRW.IRange row in usedRows.Rows)
>
>{
> if (!row.Cells[3].HasNumber)
> {
> valid = false;
> break;
> }
>}
>
>But now that we purchased a "real" version of ExcelRW, this does not work anymore. This seems to bring back all the values in a column, not a row? When I look at AddressGlobal for the row, it says $A$1:$A$7, when it should be $A$1:$G$1. I am using .NET version 1.1.
>
>David McCarter