How to write an array into excel column? [duplicate]

Question

I used Excel.Range.Value but it writes the same value to all the columns' cells.

object[] weights = new object[10000];

Excel.Range startCell = (Excel.Range)worksheet.Cells[2, cols+1];
Excel.Range endCell = (Excel.Range)worksheet.Cells[rows, cols+1];
Excel.Range writeRange = worksheet.get_Range(startCell,endCell);
writeRange.Value = weights;

I used the Excel.Range and it worked , but all the columns'cells have the same value. Note: array weights contains different values — user2188099
– user2188099, Commented May 22, 2013 at 11:13
So it didn't really "work" and you have the same problem as the guy that asked the other question. Go check it out ;) — Shark
– Shark, Commented May 22, 2013 at 11:18

Bathsheba · Accepted Answer · 2013-05-22 11:19:30Z

2

The Range.Value property takes a 2D Object for non-scalar values.

edited May 22, 2013 at 11:19

answered May 22, 2013 at 11:14

Bathsheba

235k35 gold badges376 silver badges504 bronze badges

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

7 Comments

Shark Over a year ago

That code is Visual Basic and we're on C# here.

Bathsheba Over a year ago

I've removed the code example but the Range.Value data type still stands.

Shark Over a year ago

... thus turning it into a comment at best.

Bathsheba Over a year ago

Disagree. It's the right answer.

Shark Over a year ago

But a very vague and incomplete one, especially comparing to the one in the linked question :) I'll give you an upvote however.

|

Collectives™ on Stack Overflow

How to write an array into excel column? [duplicate]

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related