|
This program shows how to automate Microsoft Excel through Visual Basic. The first section creates a new excel file, populates some of the cells, and does some basic formatting. The second section shows how to open and make modifications such as deleting rows and columns. The last section opens a Excel document and saves it as a comma separated values file (.csv). Each step in the process is fully commented to aid in learning how to automate Excel.
Download the VB.Net 2008 SP1 source code: code-exceldemoapp.zip
Screen shot:

This source is released under the GPL. |