seow
asked on
using ado to created excel files
What are the ways to read from the SQL server and generate an excel file on the fly, so that even if the client's have no excel installed, he still can view it..??
how to do it using ado..??
thanx
how to do it using ado..??
thanx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This is an odd question... if the client does not have Excel, why would you want to create a .xls file? The client MUST have Excel loaded in order to launch a .xls file in their browser. If you are parsing data from a SQL dB, just create a simple table layout populated with the required data...
ASKER
thanx.. :)
Try this, Save as Excel to html and show into client browser :
<%
Set wrd = CreateObject("Excel.Applic
wrd.Workbooks.Open Server.MapPath("aa.doc")
wrd.Visible = False
wrd.Application.ActiveWork
wrd.Application.quit
Set wrd = Nothing
Response.Redirect ("temp.html")
%>
Regards,
Wee Siong