I'm creating a spreadsheet online via ASP. I have the following at the page
top...

<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>

It works fine for some 60+ manufacturer listings. However, it balks on one
single manufacturer. By chance, this manuf has 18,000+ records. The others,
less than 10,000. Is there a limit to the number of records I can convert to
XLS...?

thanks!

I wouldn't think it's a programmatic limitation. How many records more than
18,000? Excel 2000 for example can only handle 65536 rows. What behaviour
are you seeing when it balks? Try commenting out the content-disposition
line to let the page render as HTML and see what the error message says. Is
your script timing-out?

Alan

"shank" <shank@tampabay.rr.com> wrote in message
news:%23WxrGEkMEHA.3944@tk2msftngp13.phx.gbl...[color=blue]
> I'm creating a spreadsheet online via ASP. I have the following at the[/color]
page[color=blue]
> top...
>
> <% Response.contenttype = "application/vnd.ms-excel" %>
> <% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
>
> It works fine for some 60+ manufacturer listings. However, it balks on one
> single manufacturer. By chance, this manuf has 18,000+ records. The[/color]
others,[color=blue]
> less than 10,000. Is there a limit to the number of records I can convert[/color]
to[color=blue]
> XLS...?
>
> thanks!
>
>[/color]

There's 18,587 records. I commented out this line...
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
....and no difference at all.

I get a message box that says...
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later.

I can select any other manufacturer and it works as planned. The only
difference I notice is the number of records.

thanks!


"Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
news:ekou%23HkMEHA.3232@TK2MSFTNGP11.phx.gbl...[color=blue]
> I wouldn't think it's a programmatic limitation. How many records more[/color]
than[color=blue]
> 18,000? Excel 2000 for example can only handle 65536 rows. What behaviour
> are you seeing when it balks? Try commenting out the content-disposition
> line to let the page render as HTML and see what the error message says.[/color]
Is[color=blue]
> your script timing-out?
>
> Alan
>
> "shank" <shank@tampabay.rr.com> wrote in message
> news:%23WxrGEkMEHA.3944@tk2msftngp13.phx.gbl...[color=green]
> > I'm creating a spreadsheet online via ASP. I have the following at the[/color]
> page[color=green]
> > top...
> >
> > <% Response.contenttype = "application/vnd.ms-excel" %>
> > <% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
> >
> > It works fine for some 60+ manufacturer listings. However, it balks on[/color][/color]
one[color=blue][color=green]
> > single manufacturer. By chance, this manuf has 18,000+ records. The[/color]
> others,[color=green]
> > less than 10,000. Is there a limit to the number of records I can[/color][/color]
convert[color=blue]
> to[color=green]
> > XLS...?
> >
> > thanks!
> >
> >[/color]
>
>[/color]

You might see that msg if the format of the file is incorrect. Try
commenting out the line that changes the content-type, not the
content-disposition (my mistake sorry). You should be able to render the
same output as HTML. What format is the data in as it's being rendered; an
HTML table, CSV, tab-separated?

Alan

"shank" <shank@tampabay.rr.com> wrote in message
news:ucKGy2kMEHA.3420@TK2MSFTNGP11.phx.gbl...[color=blue]
> There's 18,587 records. I commented out this line...
> <% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
> ...and no difference at all.
>
> I get a message box that says...
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later.
>
> I can select any other manufacturer and it works as planned. The only
> difference I notice is the number of records.
>
> thanks!
>
>
> "Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
> news:ekou%23HkMEHA.3232@TK2MSFTNGP11.phx.gbl...[color=green]
> > I wouldn't think it's a programmatic limitation. How many records more[/color]
> than[color=green]
> > 18,000? Excel 2000 for example can only handle 65536 rows. What[/color][/color]
behaviour[color=blue][color=green]
> > are you seeing when it balks? Try commenting out the content-disposition
> > line to let the page render as HTML and see what the error message says.[/color]
> Is[color=green]
> > your script timing-out?
> >
> > Alan
> >
> > "shank" <shank@tampabay.rr.com> wrote in message
> > news:%23WxrGEkMEHA.3944@tk2msftngp13.phx.gbl...[color=darkred]
> > > I'm creating a spreadsheet online via ASP. I have the following at the[/color]
> > page[color=darkred]
> > > top...
> > >
> > > <% Response.contenttype = "application/vnd.ms-excel" %>
> > > <% Response.AddHeader "Content-Disposition", "filename=FullList.xls"[/color][/color][/color]
%>[color=blue][color=green][color=darkred]
> > >
> > > It works fine for some 60+ manufacturer listings. However, it balks on[/color][/color]
> one[color=green][color=darkred]
> > > single manufacturer. By chance, this manuf has 18,000+ records. The[/color]
> > others,[color=darkred]
> > > less than 10,000. Is there a limit to the number of records I can[/color][/color]
> convert[color=green]
> > to[color=darkred]
> > > XLS...?
> > >
> > > thanks!
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

Thanks very much! I commented out the lines and got this error: Response
Buffer Limit Exceeded. A search on that error suggests raising the
AspBufferingLimit setting in Metabase.xml. It did have something to do with
the size of the records after all.
thanks!


"Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
news:%23f$i4nlMEHA.3712@TK2MSFTNGP10.phx.gbl...[color=blue]
> You might see that msg if the format of the file is incorrect. Try
> commenting out the line that changes the content-type, not the
> content-disposition (my mistake sorry). You should be able to render the
> same output as HTML. What format is the data in as it's being rendered; an
> HTML table, CSV, tab-separated?
>
> Alan
>
> "shank" <shank@tampabay.rr.com> wrote in message
> news:ucKGy2kMEHA.3420@TK2MSFTNGP11.phx.gbl...[color=green]
> > There's 18,587 records. I commented out this line...
> > <% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
> > ...and no difference at all.
> >
> > I get a message box that says...
> > Internet Explorer was not able to open this Internet site. The requested
> > site is either unavailable or cannot be found. Please try again later.
> >
> > I can select any other manufacturer and it works as planned. The only
> > difference I notice is the number of records.
> >
> > thanks!
> >
> >
> > "Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
> > news:ekou%23HkMEHA.3232@TK2MSFTNGP11.phx.gbl...[color=darkred]
> > > I wouldn't think it's a programmatic limitation. How many records more[/color]
> > than[color=darkred]
> > > 18,000? Excel 2000 for example can only handle 65536 rows. What[/color][/color]
> behaviour[color=green][color=darkred]
> > > are you seeing when it balks? Try commenting out the[/color][/color][/color]
content-disposition[color=blue][color=green][color=darkred]
> > > line to let the page render as HTML and see what the error message[/color][/color][/color]
says.[color=blue][color=green]
> > Is[color=darkred]
> > > your script timing-out?
> > >
> > > Alan
> > >
> > > "shank" <shank@tampabay.rr.com> wrote in message
> > > news:%23WxrGEkMEHA.3944@tk2msftngp13.phx.gbl...
> > > > I'm creating a spreadsheet online via ASP. I have the following at[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > page
> > > > top...
> > > >
> > > > <% Response.contenttype = "application/vnd.ms-excel" %>
> > > > <% Response.AddHeader "Content-Disposition", "filename=FullList.xls"[/color][/color]
> %>[color=green][color=darkred]
> > > >
> > > > It works fine for some 60+ manufacturer listings. However, it balks[/color][/color][/color]
on[color=blue][color=green]
> > one[color=darkred]
> > > > single manufacturer. By chance, this manuf has 18,000+ records. The
> > > others,
> > > > less than 10,000. Is there a limit to the number of records I can[/color]
> > convert[color=darkred]
> > > to
> > > > XLS...?
> > > >
> > > > thanks!
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]