For Programmers: Free Programming Magazines  


Home > Archive > ASP > November 2007 > generating Excel









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author generating Excel
shank

2007-11-16, 6:56 pm

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


Anthony Jones

2007-11-16, 6:56 pm

"shank" <shank@tampabay.rr.com> wrote in message
news:OrD%23jnNIIHA.1164@TK2MSFTNGP02.phx.gbl...
> 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?


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


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com