I need to insert data into an excel file and I'm using infragistics.documents.excel to do this.
I needed to know how I see which is the last column with index - In the case of this image would be the URL
I also needed to insert the data into the table as it is stored in a Private Function within a data table
The way you save 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