Modify an existing excel file

MePHyst0

New member
Joined
May 10, 2005
Messages
1
Programming Experience
1-3
Hi,

I successfully opened an Excel document with this code http://www.vbdotnetforums.com/showthread.php?t=656

As you can see it uses ADO.NET. My question is how can I update the excel file which I opened?
In my code I do something like this:


Dim DBTable As System.Data.DataTable

Dim DBTableRow As System.Data.DataRow

DBTable = DataSet.Tables.Item(0)

DBTableRow = DBTable.Rows(0)

DBTableRow.Item(0) = "Excel"


....

and now I want the changes to be reflected back to the source.


Thanx for all your answers and sorry for my dumb questions but I just can't sort it out :(


 
Top Bottom