I'm creating a spreadsheet online via ASP. I have the following at the page
top...
<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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!
4  1476 
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" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. I'm creating a spreadsheet online via ASP. I have the following at the
page top...
<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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!
There's 18,587 records. I commented out this line...
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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" <Xa***********@ Xparadise.net.n zX> wrote in message
news:ek******** ********@TK2MSF TNGP11.phx.gbl. .. 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" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. I'm creating a spreadsheet online via ASP. I have the following at the page top...
<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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!
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" <sh***@tampabay .rr.com> wrote in message
news:uc******** ******@TK2MSFTN GP11.phx.gbl... There's 18,587 records. I commented out this line...
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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" <Xa***********@ Xparadise.net.n zX> wrote in message
news:ek******** ********@TK2MSF TNGP11.phx.gbl. .. 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" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. I'm creating a spreadsheet online via ASP. I have the following at the
page top...
<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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!
Thanks very much! I commented out the lines and got this error: Response
Buffer Limit Exceeded. A search on that error suggests raising the
AspBufferingLim it setting in Metabase.xml. It did have something to do with
the size of the records after all.
thanks!
"Alan Howard" <Xa***********@ Xparadise.net.n zX> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. 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" <sh***@tampabay .rr.com> wrote in message
news:uc******** ******@TK2MSFTN GP11.phx.gbl... There's 18,587 records. I commented out this line...
<% Response.AddHea der "Content-Disposition", "filename=FullL ist.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" <Xa***********@ Xparadise.net.n zX> wrote in message
news:ek******** ********@TK2MSF TNGP11.phx.gbl. .. 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" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> I'm creating a spreadsheet online via ASP. I have the following at
the page
> top...
>
> <% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
> <% Response.AddHea der "Content-Disposition", "filename=FullL ist.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!
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: volume |
last post by:
Hi all,
In an effort to try to impress the boss, I would like to log accounting information to an Excel spreadsheet using C# and .NET. This would be a mockup only, not a real solution - yet!
We are a small ticketing company - not a bunch of IT whiz kids. ...but I do have an IT background.
I have been successful in logging (printing) tickets to a word document, and it all works kinda cool.
However, I wish to log to same information to...
|
by: A.M |
last post by:
Hi,
Using ASP.NET/VB.NET and SQL Server backend,
I need to return calculation results to user as an Access MDB file or Excel
XLS sheet.
What would be the best way to create a MDB or XLS file inside a .NET
program?
Thanks,
Ali
|
by: Raoul Snyman |
last post by:
Hi,
I need to be able to programatically create excel spreadsheets in
ASP.NET (C#), WITHOUT having MS Office on the server.
Does anybody have any advice/links/whatever for me?
Thanks in advance,
Raoul.
|
by: Gordon |
last post by:
Hello again,
Sorry to repost this request, but I'm under a bit of pressure to find a
quick solution.
All I basically want is an automatically updating link (OLE, not DDE)
between a control in my application and a cell in an Excel spreadsheet. My
control has to automatically receive updates from the spreadsheet cell.
I already know how to access the spreadsheet via the Excel.Application class
|
by: Ken Hall |
last post by:
Is it possible to create an Excel spreadsheet using VB.NET without
opening the Excel application or having to have the Excel application
on the operating computer?
KH
| | |
by: Mitch |
last post by:
I am using Access to create an Excel spreadsheets with graphs related
to rows on the sheet1 to the graph on sheet2. I am using the same data
but different subsets of the data to make different spreadsheets for
different groups. The spreadsheet formats are the same for each of the
different groups. So I am using a loop to requery the data for the
different groups and create a new spreadsheet for each group. The
three graphs on sheet 2...
|
by: vijayarl |
last post by:
Hi Everyone,
Am trying to collate the individual xls files into a single xls file.i have written this code.
use strict;
use Spreadsheet::WriteExcel;
use Spreadsheet::ParseExcel;
use Spreadsheet::WriteExcel::Big;
my $consol_rows=0;
|
by: Lindie |
last post by:
We use a spreadsheet to record attendance for pupils with special needs. They live-in so we need 365/365 attendance details. The spreadsheet is getting too cumbersome, a Db is needed.
I would like to turn the spreadsheet into a database. In the spreadsheet we have every day listed and then simply enter an attendance code.
for the Db I have 3 tables StudentDetails Attendance TeacherDetails
I use a StudentID as the primary key...
|
by: dillipkumar |
last post by:
hi,
i have one excel file, i want to create a hash of hash from the excel file, like:
%hash=
,
sheet2 => ,
....
....
];
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
