How to continue to next new excel worksheet

  • 14 years ago

    I use Response.ContentType = "application/vnd.ms-excel" in ASP in order to print out all my records in excel file.

    My problem is how to make the excel file auto continue to print the data to next new worksheet if the records is more than
    65536 rows (every worksheet only limit to 65536 rows)

    Please advise. Thanks.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.” - Bill Gates