vb.net excel manipulation
Posted on 2006-06-08
I am calling a DTS package that populates an excel spreadsheet with the data from a table in sql server. After the excel spreadsheet is populated, I would like to be able to programatically insert a new row at row 1, and in cell A1 I would like to to give the title of the spreadsheet ("Acme Accounting Report"). Any ideas on how to use excel objects from VB.net to get this done?