How to write an array into excel column?

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, May 22 '13 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, May 22 '13 at 11:18

Bathsheba · Accepted Answer · 2013-05-22T11:19:30.800

2

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

edited May 22 '13 at 11:19

answered May 22 '13 at 11:14

Bathsheba

231,907
34
361
483

That code is Visual Basic and we're on C# here. – Shark May 22 '13 at 11:15
I've removed the code example but the Range.Value data type still stands. – Bathsheba May 22 '13 at 11:18
... thus turning it into a comment at best. – Shark May 22 '13 at 11:19
Disagree. It's the right answer. – Bathsheba May 22 '13 at 11:20
2

But a very vague and incomplete one, especially comparing to the one in the linked question :) I'll give you an upvote however. – Shark May 22 '13 at 11:21
+ you too! I was wriggling slightly here as I don't know how to create a "2D Variant" in C#! – Bathsheba May 22 '13 at 11:22
Bathsheba you are right :D It works – user2188099 May 22 '13 at 11:29

How to write an array into excel column?

1 Answers1