c
int col = dt.Columns.Count;
object[,] array = new object[dt.Rows.Count, col];
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
array[i, j] = dt.Rows[i][j];
}
}
//二维数组快速给表格赋值
Excel.Range range = sheet.Range["A1:B10"];
range.Value = array;