Home All Groups Group Topic Archive Search About

Generate Excel spreadsheet from Windows form app

Author
28 Apr 2006 10:19 AM
Niclas
Hi,

I am looking to develop a Windows Forms application that collects some user
information and then as a final step generates a simple Excel spreadsheet
based on the input. I am using Visual Studio 2005 (VB) and have the Office
Development Tools installed.

Is the programmatic way to generate a spreadsheet the same as the COM model
used with Visual studio 2003 ? If anyone have a sample to how to do this the
correct way, it would be much appreciated.

Niclas

Author
28 Apr 2006 11:34 AM
Herfried K. Wagner [MVP]
"Niclas" <lindblom_nic***@hotmail.com> schrieb:
> Is the programmatic way to generate a spreadsheet the same as the COM
> model used with Visual studio 2003 ? If anyone have a sample to how to do
> this the correct way, it would be much appreciated.

How To Automate Excel from Visual Basic .NET to Fill or to Obtain Data in a
Range by Using Arrays
<URL:http://support.microsoft.com/?scid=kb;EN-US;302094>

--
M S   Herfried K. Wagner
M V P  <URL:http://dotnet.mvps.org/>
V B   <URL:http://classicvb.org/petition/>