100 ,100,100??????????????? c# 2维数组写入excel
j45kp 2008-12-16 10:34:46 c# 2维数组写入excel
int rowCount = ds.Tables[0].Rows.Count + 1; //DataTable行数+GirdHead
int colCount = ds.Tables[0].Columns.Count; //DataTable列数
//利用二维数组批量写入
string[,] arr = new string[rowCount, colCount];
for (int j = 0; j < rowCount; j++)
{
for (int k = 0; k < colCount; k++)
{
if (j == 0)
{
arr[j, k] = table.Columns[k].Caption;
}
else
{
arr[j, k] = table.Rows[j - 1][k].ToString();
}
}
}
range = app.get_Range(app.Cells[1, 1], app.Cells[rowCount, colCount]);
range.Value2 = arr;
可是就是抱HRESULT: 0x800A03EC 因为有的单元格的字符有1000多,怎么解决,现在要将30w数据导入excel分页,只有采用数组快速,现请大仙帮忙????