Edit / Modify excel file using Vb.Net.

Data in an Excel file can be manipulated using Vb.Net without even opening the file. With few steps this can be done. Previously we have created Excel file from Vb.Net with auto formatting technique. If you have missed it, then you should check this link. In this article we’ll show you how to modify data in an existing Excel file with the click of a button.

Before starting the designing of the application, we need to add a “COM” library from the reference window. In the .Net IDE, click “Project” from the top menu list and select “Add Reference…” In the “Add Reference” window, select “COM” tab and find “Microsoft Excel 12.0 Object Library” from the list. Select it and click OK.

Learn more about it.