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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problem Looping Through Excel Rows with ExcelRW

Thread ID:

Created:

Updated:

Platform:

Replies:

29121 May 17,2005 03:10 PM UTC May 26,2005 03:12 AM UTC WinForms 1
loading
Tags: XlsIO
David McCarter
Asked On May 17, 2005 03:10 PM UTC

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 26, 2005 03:12 AM UTC

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.

Warning Icon 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.Close Icon

;