Quick Excel question 1

[testare]

Is it possible to export data from a recordset to excel?

If so do you know any links that can i help me getitng started?

Of course it should be in ASP

 

[testare]

I have this in my code.
Nothing happens, when this is executed.
Same code in vb works.

%>
Set ExcelApp = Server.CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add

ExcelBook.Worksheets(1).Cells(2, 2).Font.Name = "Verdana"
ExcelBook.Worksheets(1).Cells(2, 2).Font.Size = 10
ExcelBook.Worksheets(1).Cells(2, 2).Font.Italic = true
ExcelBook.Worksheets(1).Cells(2, 2).Value="Hello world"
ExcelBook.Worksheets(1).Cells(2, 2).HorizontalAlignment = 1
ExcelBook.Worksheets(1).Cells(2, 2).Font.Color = RGB(0,0,0)

ExcelApp.Application.Quit
Set ExcelApp = Nothing 
%>

 

[tsuji]

>Nothing happens, when this is executed.
>Same code in vb works.

I don't see instruction to have it saved. How does it mean it works in vb? (Also be sure to set displayalerts to false when save---who is on the server to interact? Similarly, .visible=true is of dubious value.)

 

[FesterSXS]

Have you tried a search in this ASP forum for excel?? - there are quite a few results. One of which includes this link provided by ggriffit -

http://www.greggriffiths.org/webdev/both/excel

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[testare]

Excellent, it works now.
Many thanks.