How to capture excel value and store in object array

Question

How to set value 2D array object from excel sheet c#

object[,] DataRange = (object[,])xlrange.Value2;

I am getting error "Unable to cast object of type 'System.String' to type 'System.Object[,]".

I need solution for same

Instead of object have you then tried to use strings?

Allan S. Hansen
– Allan S. Hansen

2014-05-08 05:41:16 +00:00
Commented May 8, 2014 at 5:41 — Allan S. Hansen
– Allan S. Hansen, Commented May 8, 2014 at 5:41

CtrlDot · Accepted Answer · 2014-05-08 05:43:08Z

2

If your case, xlrange is probably a single cell. Try testing it with if(xlrange.Count > 1). You will need to handle single cells separately.

answered May 8, 2014 at 5:43

CtrlDot

3,1223 gold badges26 silver badges32 bronze badges

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

1 Comment

user3217843 Over a year ago

I want to use multidimensional array objects strings is working

Scott Gall · Accepted Answer · 2016-05-12 02:17:20Z

0

May I suggest you capture the case of it being a single cell and cast it into the object array. Then you can work on it from there consistently.

Please note another gotcha you will run into here is that 1D Ranges in excel will result in 0 based object arrays returned where 2D Ranges will be 1 based.

I suggest identifying the type, always casting to a 2D 1 based, then work consistently on the 2d 1 based arrays, and convert back if/when you need to write it back into excel.

answered May 12, 2016 at 2:17

Scott Gall

1464 bronze badges

Collectives™ on Stack Overflow

How to capture excel value and store in object array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related