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.

Single cell file

Thread ID:

Created:

Updated:

Platform:

Replies:

13219 Apr 22,2004 06:59 PM Apr 26,2004 06:59 AM Windows Forms 3
loading
Tags: XlsIO
Greg
Asked On April 22, 2004 06:59 PM

If I create a file in Excel that has a number in only a single cell, RW says there is a cell, but has no Text. If I go back to Excel and type something into a second cell, then RW is able to provide the text for both. Wishing you the best, Greg

Administrator [Syncfusion]
Replied On April 24, 2004 01:17 AM

Hi Greg, Could you give me more details on this issue. Please let me know if my assumptions are correct. 1) You have a workbook with only one cell filled. 2) You try to read the value in that cell. Please post the code snippet that you use for reading the cell. This would help me understand your requirement clearly. Thanks. Best regards, Stephen. >If I create a file in Excel that has a number in only a single cell, RW says there is a cell, but has no Text. If I go back to Excel and type something into a second cell, then RW is able to provide the text for both. > >Wishing you the best, >Greg

Greg
Replied On April 24, 2004 08:51 AM

Very basic access. I didn''t know anything existed besides ExcelUtils. I will be interested in some type of array read to speed things up. workBook = ExcelUtils.Open(strFile); foreach (IWorksheet wk in workBook.Worksheets) { foreach (IRange ecell in wk.Cells) { if (ecell.Text == null || ecell.Text == "") continue; } // work with cell }

Administrator [Syncfusion]
Replied On April 26, 2004 06:59 AM

Hi Greg, Thanks for the code snippet. I see the problem now. We will fix it in the next release. Thank you for your patience. Best regards, Stephen. >Very basic access. I didn''t know anything existed besides ExcelUtils. I will be interested in some type of array read to speed things up. > >workBook = ExcelUtils.Open(strFile); >foreach (IWorksheet wk in workBook.Worksheets) >{ > foreach (IRange ecell in wk.Cells) > { > if (ecell.Text == null || ecell.Text == "") > continue; > } > // work with cell >} >

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.

;