Excel in ASP.NET

Hello,

I would like to know how can i make a Excel file in the server and mail it to some one.
The problem is the fact that the server don't have the Excel installed.

Thanks in advance.
JC
jcintraAsked:
Who is Participating?
 
Thandava VallepalliConnect With a Mentor Commented:
Hi,

First try with this code...
==================================
<%@ language=vbscript %>
<%
Response.ContentType = "application/vnd.ms-excel"
%>
<TABLE>
<TR>
<TD>
<!-- Cell : A1 -->
2
</TD>
</TR>
<TR>
<TD>
<!-- Cell : A2 -->
3
</TD>
</TR>
<TR>
<TD>
<!-- Cell : A3 -->
=SUM(A1:A2)
</TD>
</TR>
</TABLE>
=================================

Make this file as .asp.  And access this application.

It will open this content in excel.    

For sending mails.  Prepare the excel content like below and save this file as  .xls  and send this file as attachment.

=============================
<TABLE>
<TR>
<TD>
<!-- Cell : A1 -->
2
</TD>
</TR>
<TR>
<TD>
<!-- Cell : A2 -->
3
</TD>
</TR>
<TR>
<TD>
<!-- Cell : A3 -->
=SUM(A1:A2)
</TD>
</TR>
</TABLE>
====================================

All the best,
V.Thandava Krishna.
0
 
Thandava VallepalliCommented:
Hi,

Still have any problmes look at this link.....


http://forums.aspfree.com/t19349/s008573c7e2a326b074b5d7a591b5448b.html

All the best,
V.Thandava krishna.
0
All Courses

From novice to tech pro — start learning today.