N
Navin
hi,
i am using the following code to generate a xls file using the
content type
now when the user opnes the file at his pc it takes long time to
open..if the no of records in file is large
does the use of html tags has slow down the process of opening in
excel...
does speical care needs to be taken so that large html files open in
excel quiclky.....................
Please advise your feedback....
Response.ContentType = "application/vnd.ms-excel"
Response.Write("<basefont face=""Arial Narrow"" size = ""2""
color=""#000000"">")
Response.Write("<TABLE border = 0 color=blue align=left>")
Response.Write("<TR>")
Response.Write("<td colspan = 8><font size=4><b>Indirect Channels -
Management Information System</b></font></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 7><font size=3><b>" & strRptName &
"</b></font></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>User Id : " & session("userid") &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>User Name : " &
session("username") & "</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>Period From : " & strPeriodFrom &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>Period To : " & strPeriodTo &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>IN CONFIDENCE</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("</TABLE>")
i am using the following code to generate a xls file using the
content type
now when the user opnes the file at his pc it takes long time to
open..if the no of records in file is large
does the use of html tags has slow down the process of opening in
excel...
does speical care needs to be taken so that large html files open in
excel quiclky.....................
Please advise your feedback....
Response.ContentType = "application/vnd.ms-excel"
Response.Write("<basefont face=""Arial Narrow"" size = ""2""
color=""#000000"">")
Response.Write("<TABLE border = 0 color=blue align=left>")
Response.Write("<TR>")
Response.Write("<td colspan = 8><font size=4><b>Indirect Channels -
Management Information System</b></font></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 7><font size=3><b>" & strRptName &
"</b></font></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>User Id : " & session("userid") &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>User Name : " &
session("username") & "</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>Period From : " & strPeriodFrom &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>Period To : " & strPeriodTo &
"</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write("<td colspan = 4><b>IN CONFIDENCE</b></td>")
Response.Write("</TR>")
Response.Write("<TR>")
Response.Write(" ")
Response.Write("</TR>")
Response.Write("</TABLE>")