日期:2014-05-17  浏览次数:20498 次

ASP.NET 导出excel 数据量大的问题

tbs.Length =2012;
ps.lengt=60;
   if (tbs.HasMember())
                    {
                        var ps = tbs[0].GetType().GetProperties();
                        int z = tbs.Length;
                        int h = ps.Length;
                        for (int i = 0; i < tbs.Length; i++)
                        {
                            for (int j = 0; j < ps.Length; j++)
                            {
                                sheet.Cells[9 + i, 1 + j] = ps[j].GetValue(tbs[i], null);
                            }
                        }
                    }
                }

asp.net 数据 excel

------解决方案--------------------
可以看我的blog,连续的EXCEL单元格写入加速
http://blog.csdn.net/longjuesi/article/details/9819377