how to reduce the file size while exporting to excel in c#?

Posted by Prabu_Spark under ASP.NET on 6/26/2013 | Points: 10 | Views : 1364 | Status : [Member] | Replies : 1
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.

With regards,


Posted by: Allemahesh on: 6/27/2013 [Member] [MVP] Silver | Points: 25

You can programatically .zip or .rar the excel file and then give a download link to download the file.
Hope this will help you.

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response