click in image then export to excel

angela · #1 (**permalink**) 03-20-04, 12:08 AM

Hello

How do i export the table to the excel spreadsheet? i need to export the table below to the excel spreadsheet... i need to click on an image that can link to show the table on the spreadsheet...but how do i do that?

or do i need to do it in another asp page..

IF CustQuery.EOF Then
%>

<tr bgcolor="#FFFFFF" height="5">
<td>No records for this Month</td>
</tr>
<%
Else
'Tells the browser to open excel
If(rowCount MOD 2 = 0) Then
%>

<tr bgcolor="#FFFFFF" height="5">
<td><%=CustQuery("Given_Name")%></td>
<td><%=CustQuery("Family_Name")%></td>
<td><%=CustQuery("Company_Name")%></td>
<td><%=CustQuery("BusinessPhone")%></td>
<td><%=CustQuery("Email")%></td>
</tr>
<%
Else
%>
<tr bgcolor="#EFEFEF" height="5">
<td><%=CustQuery("Given_Name")%></td>
<td><%=CustQuery("Family_Name")%></td>
<td><%=CustQuery("Company_Name")%></td>
<td><%=CustQuery("BusinessPhone")%></td>
<td><%=CustQuery("Email")%></td>
</tr>

<%
'CustQuery.MoveNext()
'Loop

End If ' end for rowcount
rowCount = rowCount + 1

End If
Next

CustQuery.Close
Set CustQuery = Nothing

<a href="<%Response.ContentType = "application/vnd.ms-excel"%>" onmouseout="return window.status=''" target="_blank">
<img border="0" src="images/xl.gif"></a>Export list to Excel</tr>

i am refering to the code below...but still don't get it....
http://www.codeave.com/asp/code.asp?u_log=40

Shane · #2 (**permalink**) 03-23-04, 07:55 PM

Quote:

Originally Posted by angela

Hello

How do i export the table to the excel spreadsheet? i need to export the table below to the excel spreadsheet... i need to click on an image that can link to show the table on the spreadsheet...but how do i do that?

or do i need to do it in another asp page..

IF CustQuery.EOF Then
%>

<tr bgcolor="#FFFFFF" height="5">
<td>No records for this Month</td>
</tr>
<%
Else
'Tells the browser to open excel
If(rowCount MOD 2 = 0) Then
%>

<tr bgcolor="#FFFFFF" height="5">
<td><%=CustQuery("Given_Name")%></td>
<td><%=CustQuery("Family_Name")%></td>
<td><%=CustQuery("Company_Name")%></td>
<td><%=CustQuery("BusinessPhone")%></td>
<td><%=CustQuery("Email")%></td>
</tr>
<%
Else
%>
<tr bgcolor="#EFEFEF" height="5">
<td><%=CustQuery("Given_Name")%></td>
<td><%=CustQuery("Family_Name")%></td>
<td><%=CustQuery("Company_Name")%></td>
<td><%=CustQuery("BusinessPhone")%></td>
<td><%=CustQuery("Email")%></td>
</tr>

<%
'CustQuery.MoveNext()
'Loop

End If ' end for rowcount
rowCount = rowCount + 1

End If
Next

CustQuery.Close
Set CustQuery = Nothing

<a href="<%Response.ContentType = "application/vnd.ms-excel"%>" onmouseout="return window.status=''" target="_blank">
<img border="0" src="images/xl.gif"></a>Export list to Excel</tr>

i am refering to the code below...but still don't get it....
http://www.codeave.com/asp/code.asp?u_log=40

Just do it in a separate asp page. Use your existing ASP page (ie. copy it and rename it) , but put the Response.ContentType="application/vnd.ms-excel" call at the very top of the page before any html has been sent back.

cgm · #3 (**permalink**) 06-10-04, 11:29 AM

Hi. That way works perfect.
But if I want to click in image then export to excel directly, like I do right click then select "Export To Microsoft Excel". How do I do.

someone has idea? Thanks

dypsoprogram · #4 (**permalink**) 09-02-05, 07:53 PM

Hi, let have a look here : http://dypso.free.fr/tech

maryjok3698 · #5 (**permalink**) 09-02-10, 06:55 AM

Hello,
Here is c# excel/vb.net excel /asp.net excel component can do this easy, it's named Spire.XLS. I use it from last year.

Hope help to you.