[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

How to create an Excel 2003 spreadsheet from vb.net ?

Robin Prosch via .NET 247

4/10/2005 5:38:00 AM

Hi,
I had this code which worked with Excel 2000

Dim xl As New Excel.ExcelApplication
xl.Workbooks.Add()

Dim dc As DataColumn = New DataColumn
Dim i As Integer = 0
For Each dc In ds.Tables(0).Columns
xl.Range("A1").Offset(0, i).Value = dc.ColumnName
i += 1
Next

---- more code----------

xl.SaveWorkspace("C:\temp1.xls")


But this code does not work with Excel 2003 anymore. Any help will be greatly appreciated.

--------------------------------
From: Tarun Kapoor

-----------------------
Posted by a user from .NET 247 (http://www.dotn...)

<Id>KB5sFxYG/kKTa9yBMx3oZQ==</Id>