Visual Studio Tools for OfficeBe sure to specify which version you are working with.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Visual Studio Tools for Office section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
Value = null for cell with numeric format General.
Hi,
I have a problem to get single numeric values from an Excel worksheet (that I need to process as I receive it).
I use the Microsoft Excel 9.0 Library because I need to process EXcel 2000/2003 files.
This is the range:
Only in case of format 0.0 I can get a value (e.g. 234.9) like this:
Result = Convert.ToDouble(CellRange.Value);
MessageBox.Show(Result.ToString());
But the format can also be General with values e.g. 234.9 (with point), 234,9 (with comma) or 2349 (without separator).
The value property is null for a cell with numeric format General.
It must be simple, but I can't find the solution.
Who can help me?
Value = null for cell with numeric format General.
Linear Mode
