Excel not properly displaying an array

Question

Excel seems to display the first element of an array over and over in a column with the following code

      Dim fileNum() As String = {"1", "2"}
    xlSourceRange = xlWorkSheet.Range("N2:N" & fileNum.Length + 1)
    xlSourceRange.Value2 = fileNum

The entire range just fills up with 1. How can I make it so each element in the array is displayed in the column without having to manually assign each cell in a loop. I'm using the Microsoft.Office.Interlop.Excel if that matters.

John Bustos · Accepted Answer · 2012-10-23 21:33:59Z

1

Ok, now i got to an IDE so I can answer more intelligently. The problem is the array - Unfortunately, Excel adds ranges based upon a 2-d array. For your specific example, this bit of code would give you what you are looking for:

    Dim fileNum() As object = {{"1"}, {"2"}}
    xlSourceRange = xlWorkSheet.Range("N2:N" & fileNum.Length + 1)
    xlSourceRange.Value = fileNum

Hope this does the trick!

answered Oct 23, 2012 at 21:33

John Bustos

19.7k18 gold badges102 silver badges162 bronze badges

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

3 Comments

Tony Over a year ago

You should edit your original answer if you think this is the correct approach. Alternatively delete your previous answer.

Austin Davis Over a year ago

It worked thank you so very much. I was wondering how would you convert a one dimensional array of objects to a 2-D array of objects?

John Bustos Over a year ago

Just create a new array - Dim x(,) as Object - Then you can populate it using a for loop.

Collectives™ on Stack Overflow

Excel not properly displaying an array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related