Single cell file

[Greg]

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]

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]

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]

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