Excel Spreadsheet Question

[born2program]

How do you use a excel com object in vb.net behind a asp.net page. I have tried using the following code but is not successful. I basically need to be able to write to a spreadsheet cell by cell from a dataset (not just push a whole datagrid out to excel). Any help is appreciated. Thanks.

Dim xl As Excel.Application
        Dim book As Workbook
        Dim sheet As Worksheet


        xl = CreateObject("Excel.Application")
        xl.Visible = True

 

[Rhys666]

Look up office interop

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra

Church of the Flying Spaghetti Monster

 

[jmeckley]

personall I like CarlosAg Excel Writer. it doesn't require the Office Interop assemblies. I found these to be slow and not developer friendly in terms of property/function naming.

If you use the Office Interop files you must have MS Office installed on the server. You cannot just use the assemblies. This was the case when I experimented with it.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[Rhys666]

jmeckley
I like the idea of what you suggest and it may be very good in most situations, but the library you referenced does not really do what the poster wants. They produce xml output that recent generations of excel can interpret and open as a spreadsheet.

I'm still going to look at them more though

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra

Church of the Flying Spaghetti Monster

 

[Chance1234]

Im currently working with the OWC components. In short they are a pain!!!!

This link might help you get started

http://www.4guysfromrolla.com/webtech/022801-1.shtml

Chance,

Filmmaker, gentleman and polla stilo eleous