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
– Soner Gönül, Commented May 14, 2015 at 7:11
@SonerGönül Exception: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException Can't convert double to string. Value2 is dynamic :) — demonplus
– demonplus, Commented May 14, 2015 at 7:14
@RezaArabQaeni yes, I just found similar answer myself, see below, Excel often returns null values also — demonplus
– demonplus, Commented May 14, 2015 at 7:31
FYI - That will blow up when range is more than 1 cell as .Value2 will return an object[] array — Leo Gurdian
– Leo Gurdian, Commented Mar 21, 2017 at 21:39

demonplus · Accepted Answer · 2015-05-14 07:30:10Z

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, 2015 at 7:30

demonplus

5,84912 gold badges56 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Casting Range.Value2 of Excel interop to string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related