christine_wmw 0 Newbie Poster

Hi,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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.