Casting Range.Value2 of Excel interop to string

Question

I import some values from Excel sheets in C# application. One column is a text basically but can contain any values. I used the following:

Range range = ... // getting this from Excel, works fine
string myString = (string)range.Value2;

When the cell contains text, this is working. But when it contains, for example, 123, the debugger shows 123.0 for range.Value2 and conversion to string fails with exception.

I wonder, how to write the most general conversion for all kinds of cells. At least string and integer, may be float content.

What is the type and value of `Value2` exactly? What is the exception message? — Soner Gönül, May 14 '15 at 07:11
@SonerGönül Exception: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException Can't convert double to string. Value2 is dynamic :) — demonplus, May 14 '15 at 07:14
@RezaArabQaeni yes, I just found similar answer myself, see below, Excel often returns null values also — demonplus, May 14 '15 at 07:31
FYI - That will blow up when range is more than 1 cell as .Value2 will return an object[] array — Leo Gurdian, Mar 21 '17 at 21:39

score 5 · Accepted Answer · answered May 14 '15 at 07:30

5

I found the solution which may be not so nice but works:

myString = range.Value2 == null ? "" : range.Value2.ToString();

May be something better exists.

answered May 14 '15 at 07:30

demonplus

5,613
12
49
68

Casting Range.Value2 of Excel interop to string

1 Answers1

Linked