generating Excel - ASP / Active Server Pages

shank

I'm generating excel spreadsheets online with many manufacturers. One
particular manufacturer has 5000 more records than the next highest. When I
query for that manuf the table does not form. Just plain text. It doesn't
time out. Just doesn't form properly.

Is there a cache or setting I need to increase to get this much data?

thanks

Nov 7 '07 #1

Subscribe Post Reply

1596

Anthony Jones

"shank" <sh***@tampabay.rr.comwrote in message
news:Or****************@TK2MSFTNGP02.phx.gbl...

I'm generating excel spreadsheets online with many manufacturers. One
particular manufacturer has 5000 more records than the next highest. When

query for that manuf the table does not form. Just plain text. It doesn't
time out. Just doesn't form properly.

Is there a cache or setting I need to increase to get this much data?

Just how much data is one record in bytes on average?

"One particular manufacturer has 5000 more records than the next highest."
Since you don't state how many records "the next highest" actually the above
statement is next to useless. How many records is it?

Some code showing how you generate the output would be useful?
Are you building a string then writing the response or are you writing to
the response once per record?
Is response buffering turned on?

--
Anthony Jones - MVP ASP/ASP.NET

Nov 8 '07 #2

Similar topics

generating excel sheet

by: Rajiv | last post by:

HI ALL, actually , i m working in a company having large number of employee , i have two userid and password . on id is from admin group(id given to me by technology manager) of the server and...

ASP / Active Server Pages

Generating Excel with HTML

by: Evan T. Basalik | last post by:

In my ASP.NET application, I have a table (really a datagrid) that I am converting into an Excel sheet using ContentType = "application/vnd.ms-excel". It seems to work fine for most of my results,...

ASP.NET

prob forms authentication while generating excel report

by: Raghavendra | last post by:

hi, we r using forms authetication. problem :- i am using the below code to generate excel report but since we r using forms authetication.. after generating excel report the browser directs...

ASP.NET

generating MS-Excel report through ASP.Net without installing MS-E

by: hari krishna | last post by:

hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in...

ASP.NET

Generating XLS files from ASP

by: daniele.balducci | last post by:

Hi All, I'm generating XLS files from ASP(.Net) code using the usual code chunks ... Response.ContentType = "application/vnd.ms-excel" Response.AppendHeader("Content-Disposition", "attachment;...

ASP.NET

Generating XML from Excel / Trapping saved Excel file using FileSystemWatcher

by: Rich Wallace | last post by:

Hello all, Looking for suggestions and tips if possible. I have an application running on a file server that utilizes the FileSystemWatcher to trap when any Excel files are saved by a user. I...

Visual Basic .NET

generating Excel files w/ .NET? (an ASP.NET, C# web app)

by: matt | last post by:

hello, can anyone speak to some of the common or preferred methods for building Excel .XLS files, programmatically thru the .NET framework? i have an intranet app that needs to generate &...

ASP.NET

Generating an Excel File without using Interops

by: Kuldeep | last post by:

Framework: Visual Studio 2005 Technology: ASP.NET 2.0 Language: C#.NET 2.0 Hi All, How can we generate an Excel File through C#.NET without using Interops or XML ? Any leads on this would...

C# / C Sharp

generating an excel file in vb 6.0

by: veer | last post by:

hello expert i want to generate excel file in vb through coding, i use the following code to generate excel sheet Dim AppXls As Excel.Application Dim ObjWb As Excel.Workbook Dim ObjWs As...

Visual Basic 4 / 5 / 6

How to GET DATA from Microsoft EXCEL Sheets for Generating REPORTS in SSRS 2005..

by: Aswanth | last post by:

I'm Using Asp.Net with C# & SSRS 2005 for Generating Reports.. I'm Having HUGE Data in Microsoft Excel Sheets .. I want to Get this Data from this Microsoft Excel Sheets & to Generate REPORTS in...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA