/// <summary>
/// DataTable转换成二维数组(excel从1开始)
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static object[,] ToArray(DataTable dt)
{
Array arr = Array.CreateInstance(typeof(object), new Int32[] { dt.Rows.Count, dt.Columns.Count }, new Int32[] { 1, 1 });
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
arr.SetValue(dt.Rows[i][j], i+1, j+1);
}
return (object[,])arr;
}