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

Posted by Prabu_Spark under ASP.NET on 6/26/2013 | Points: 10 | Views : 2693 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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,
J.Prabu.
[Email:prbspark@gmail.com]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...