How to open large HTML FILES IN EXCEL In quick Time

Discussion in 'ASP General' started by Navin, Jan 13, 2004.

  1. Navin

    Navin Guest

    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("&nbsp")
    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("&nbsp")
    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("&nbsp")
    Response.Write("</TR>")
    Response.Write("<TR>")
    Response.Write("<td colspan = 4><b>IN CONFIDENCE</b></td>")
    Response.Write("</TR>")
    Response.Write("<TR>")
    Response.Write("&nbsp")
    Response.Write("</TR>")
    Response.Write("</TABLE>")
     
    Navin, Jan 13, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dena Jo

    Quick Time files in HTML

    Dena Jo, Nov 10, 2003, in forum: HTML
    Replies:
    4
    Views:
    460
    Whitecrest
    Nov 10, 2003
  2. JKop
    Replies:
    11
    Views:
    1,174
  3. Alexandre Guimond
    Replies:
    0
    Views:
    487
    Alexandre Guimond
    May 25, 2006
  4. flamesrock
    Replies:
    8
    Views:
    802
    Hendrik van Rooyen
    Nov 24, 2006
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,981
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  6. eddie wang
    Replies:
    0
    Views:
    582
    eddie wang
    Oct 3, 2003
  7. Clement Ow
    Replies:
    0
    Views:
    219
    Clement Ow
    Apr 4, 2008
  8. Replies:
    7
    Views:
    356
    Big and Blue
    Dec 30, 2005
Loading...