insert data into an excel spreadsheet

Question

I need to insert data into an excel file and am using Infragistics.documents.excel for that reason.

needed to know how to see which is the last column with Indice - In the case of this image would be the URL

also needed to insert the data into the table and they are stored in a Private Function within a data table

how to store the data for the data to be saved is as follows

Using t As New DataTable
                da.Fill(t)

                For Each Row In t.Rows
                    Dim e As New ExportLine
                    e.Url = String.Format(Url, Row!ClienteId)
                    e.Nome = Row!Nome
                    e.Telemovel = Row!Telemovel
                    lExportLines.Add(e)
                Next
            End Using

Answer 1

I resolved with

`For Each dados In lExportLines

        oWorksheet.Rows.Item(iRow).Cells(iCol).Value = dados.Nome

        iCol += 1I
        oWorksheet.Rows.Item(iRow).Cells(iCol).Value = dados.Telemovel
        iCol += 1I
        oWorksheet.Rows.Item(iRow).Cells(iCol).Value = dados.Url
        iCol = 1I
        iRow += 1I

    Next`