ASP to Excel Problems

bikebanditcom · Oct 12, 2003

i am trying to generate a excel chart from a recordset that can be saved (i'd be nice if it would save and display) but i can deal with having the user hit file - save as. the following is my page can anyone tell me why the chart comes up blank?

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Response.ContentType = "application/vnd.ms-excel"

set pbcDB = server.createObject("ADODB.Connection&quot

pbcDB.open "pbc"

set objrs=pbcDB.execute("select * from tblUsers&quot

%>
<TABLE BORDER=1>
<TR>
<%

' Loop through each Field, printing out the Field Names

For i = 0 to objrs.fields.count - 1
%>
<TD><% = objrs(i).name %></TD>
<% next %>
</TR>
<%

' Loop through rows, displaying each field

while not objrs.eof
%>
<TR>
<% For i = 0 to objrs.fields.count - 1
%>
<TD VALIGN=TOP><% = objrs(i) %></TD>
<% Next %>

</TR>
<%
objrs.MoveNext

wend

objrs.Close
pbcDB.close
set pbcDB = Nothing
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "

http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

</body>
</html>

clarkin · Oct 12, 2003

Well, you have a badly formed HTML file so excel has trouble finding the table inside it. Comment out the Response.ContentType line temporarily - then get your page to output a html file with the table & table data in it. When this is working, add the line back in and see it in excel.

Basically you want this section:

Code:

<!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot; &quot;[URL unfurl="true"]http://www.w3.org/TR/html4/loose.dtd&quot;>;[/URL]
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;>
</head>

<body>

right above the <TABLE BORDER=1>

Posting code? Wrap it with code tags: [ignore]

Code:

[/ignore][code]CodeHere

[ignore][/code][/ignore].

bikebanditcom · Oct 12, 2003

thank you very much .It works perfectly now. thanks

dan

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ASP to Excel Problems

bikebanditcom

Programmer

clarkin

Programmer

bikebanditcom

Programmer

Similar threads

Part and Inventory Search

Sponsor