Click here to Skip to main content
11,922,641 members (56,398 online)
Rate this:
Please Sign up or sign in to vote.
See more: ASP.NET
Hi sir,
I developed application that exports dataset value to excel. I am having 10,500 records and 17 columns in the table. If i export
to excel file, it takes more than 25 MB, i cant able to open the exported excel file, it shows loading symbol for long time.
Kindly give me the solution for this problem.
Posted 26-Jun-13 2:32am
ThePhantomUpvoter 26-Jun-13 7:40am
A solution to what problem? Export less data or split the data into multiple files.
aspnet -i 26-Jun-13 9:42am
I agree, he should export less data in the excel.. Who is going to read 10500 records ??????

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I think the quickest solution is to export data as CSV. This should significantly reduce the file size and you can easily open a CSV file in Excel.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web03 | 2.8.151125.1 | Last Updated 28 Jun 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100