在MVC3中导出到Excel以获取大数据 [英] Export to Excel in MVC3 for large data

问题描述

Hello

I developed application that exports dataset value to excel in mvc3. I am having about 60,000 records and 22 columns in the table. If i export 
to excel file, it takes more than 16 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.

推荐答案

很抱歉，但是你没有提供有关你的问题的足够信息，就像你用来将数据导出到MS Excel文件等的方法一样。然而......



如果22列中有大约60K记录，Excel文件可能会接管16 MB。使用格式化会导致文件连续增长。





提示：下次，请更具体;）

Sorry, but you did not provide enough information about your issue, like the method you used to export data to MS Excel file, etc. Nevertheless...

If you have about 60K records in 22 columns, Excel file could takes over 16 MB. Using formatting causes successive file growth.


Tip: Next time, please be more specific ;)

这篇关于在MVC3中导出到Excel以获取大数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！