How to export the report(generate by ASP in html form) to microsoft excel??????

[why liew]

Hi,now i am facing the big problem while doing my projek and i don't

have any solution to solve it.So i hope all of my dearest member can

help me.

The problems are following:-
i) How to export the report(generate by ASP in html form) to microsoft

excel?
ii) When the report was sucecc export to microsoft excel,can i editing

the report ?
iii) can i standardlize the report format such as report letter

head,report label and etc before i export the report(generate by ASP in

html form) to microsoft excel?

so hopefully all of my dearest member can help me!!!!! :confused: :confused: :confused:

tq very much.

[Bullschmidt]

Perhaps add the ability for the user to download a CSV file which can easily be opened in Excel.

Puzzle 5 Not much different from other solutions by Manohar Kamath posted 1/12/99
http://www.asp101.com/puzzles/puzzle5_s7.asp

Or:

Creating a Dynamic Report using ASP and Excel by Jeff Anderson - 1/9/2003
http://www.codetoad.com/asp_excel.asp

Output To MSExcel
http://www.codeave.com/asp/code.asp?u_log=40

ASP Tutorial: Dynamic Excel Reports
http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp

VBScript and Excel
http://www.greggriffiths.org/webdev/both/excel/

HOWTO: Extract Information from Excel Sheet with DAO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;190195

[Illufox]

Simply add the following at the top of your resulting page:

<%
Response.ContentType = "application/vnd.ms-excel"
%>