We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Problem Looping Through Excel Rows with ExcelRW

Thread ID:

Created:

Updated:

Platform:

Replies:

29121 May 17,2005 11:10 AM May 25,2005 11:12 PM Windows Forms 1
loading
Tags: XlsIO
David McCarter
Asked On May 17, 2005 11:10 AM

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 [Syncfusion]
Replied On May 25, 2005 11:12 PM

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;