Value of type 'General' cell different from 'Number' or 'Text'?

[Gijs]

Hi,
I have a problem to get single numeric values from an Excel worksheet (that
I need to process as I receive it).
The Value property is null for a type General field.
The Value property contains the right value in case of number or text type.
I use the Microsoft Excel 9.0 Library (and C#) because I need to process
Excel 2000/2003 files.
It must be simple, but I can't find the solution.
Who can help me?

Thanks,
Gijs

 

[Joel]

Read the value as text. you can then use then can test the string in C# using
IsNumber().

 

[Gijs]

Read the value as text. you can then use then can test the string in C# using
IsNumber().






- Tekst uit oorspronkelijk bericht weergeven -

The 'Value' is null and the 'Text' is emtry "".
Where is the cell contents stored in case of NumberFormat = General?
Thanks,
Gijs

 

[Joel]

The cell contents text is always stored in the same location. Number and
text may end up in a different class an be right or left justified. I think
it would be better just to force text to be read. Then do you own type
conversion is C#.

In excel yo sometimes end up with spaces in front or at the end of a number
which would convert the number to text. I often in excel vba perform a trim
to get rid of extra spaces. A worksheet is entered by hand and not by a
program. People often type extra spaces into excel worksheets. Programs
then have a lot of problems handling the extra space conditions.