How to export array to Excel worksheet?

Question

I have an array with 4 columns and close to 25 rows. I want to know how to export it to an excel sheet. I'd like the elements in the array to appear at once inn the excel sheet when run.

Dim matrix(4,25) As String

Possible duplicate of In VB.Net, how to write an Array to Excel — aphoria
– aphoria, Commented Jun 15, 2016 at 19:42

Fred · Accepted Answer · 2016-06-15 19:25:44Z

0

Assuming you want to do it in vb.net, this should do it.

Sub Main()
    Dim oExcel As Object = CreateObject("Excel.Application")
    Dim oBook As Object = oExcel.Workbooks.Open("C:\Book1.xlsx")
    Dim oSheet As Object = oBook.Worksheets(1)
    Dim matrix(4, 25) As String
    Dim i As Integer
    Dim j As Integer

    'populate matrix
    For i = 1 To 4
        For j = 1 To 25
            matrix(i, j) = i & "  " & j
        Next j
    Next i

    'move to excel worksheet
    For i = 1 To 4
        For j = 1 To 25
            oSheet.cells(j, i).Value = matrix(i, j)
        Next j
    Next i

    'Save this Excel document
    oBook.SaveAs("C:\Book1.xls", True)
    oExcel.Quit()
End Sub

answered Jun 15, 2016 at 19:25

Fred

363 bronze badges

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

Collectives™ on Stack Overflow

How to export array to Excel worksheet?

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