Link to home
Start Free TrialLog in
Avatar of seow
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
ASKER CERTIFIED SOLUTION
Avatar of puranik_p
puranik_p
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of weesiong
weesiong

seow,

Try this, Save as Excel to html and show into client browser :

<%
Set wrd = CreateObject("Excel.Application")
wrd.Workbooks.Open Server.MapPath("aa.doc")
wrd.Visible = False

wrd.Application.ActiveWorkbook.SaveAs Server.MapPath("temp.html"), 8
wrd.Application.quit
Set wrd = Nothing

Response.Redirect ("temp.html")
%>

Regards,
Wee Siong
Avatar of Mark Franz
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...

Avatar of seow

ASKER

thanx..  :)