Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open large HTML FILES IN EXCEL In quick Time
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<bIndirect 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<bUser Id : " & session("userid") & "</b</td") Response.Write("</TR") Response.Write("<TR") Response.Write("<td colspan = 4<bUser Name : " & session("username") & "</b</td") Response.Write("</TR") Response.Write("<TR") Response.Write("<td colspan = 4<bPeriod From : " & strPeriodFrom & "</b</td") Response.Write("</TR") Response.Write("<TR") Response.Write("<td colspan = 4<bPeriod To : " & strPeriodTo & "</b</td") Response.Write("</TR") Response.Write("<TR") Response.Write(" ") Response.Write("</TR") Response.Write("<TR") Response.Write("<td colspan = 4<bIN CONFIDENCE</b</td") Response.Write("</TR") Response.Write("<TR") Response.Write(" ") Response.Write("</TR") Response.Write("</TABLE") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open large HTML FILES IN EXCEL In quick Time
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files take long time to open | Excel Worksheet Functions | |||
All excel files taking time to open | Excel Discussion (Misc queries) | |||
Files don't open first time EXCEL 97 | Excel Discussion (Misc queries) | |||
Excel 2007 €“ Files will not open a second time. | Excel Discussion (Misc queries) | |||
How to open large HTML FILES IN EXCEL In quick Time | Excel Programming |