Manipulating Excel from VB.Net
Posted on 2005-03-07
How can I do the following Excel operations from my VB.Net program ?
1. If a particular .xls file is already open by the user, then lock it so that for the duration of my program, the user cannot make ANY changes to the Excel workbook ?
2. Insert some values in an Excel workbook. Pls give example with any dummy values.
3. In a particular sheet in the workbook, find the last such row where any data has been entered in any of the columns. I need this so that I can insert data from my program in the NEXT row.
Bascially I am writing a program which is run once daily and which reads values from an Access database and appends them in an Excel workbook on a daily basis. Every day it has to add one row of data to the already existing values.
Thnx. I will appreciate any code samples or relevant links.