从gridview中一个一个celll导出到excel太慢,有好的办法吗,谢谢
如题,代码如下:
//添加标题
for (int i = 0; i < columncnt; i++)
{
wsheet.Cells[1, i + 1] = GridView1.HeaderRow.Cells[i].Text;
}
//添加数据
for (int i = 0; i < rowcnt; i++)
{
for (int j = 0; j < columncnt; j++)
{
wsheet.Cells[i + 2, j + 1] = GridView1.Rows[i].Cells[j].Text;
}
}