将二位数组的数据导入到excle中
小弟又遇到问题了以前做VB的 excel还算顺手，这次让做C#的 对于语法上的转换还是有些困难，希望各位帮忙，上代码
object[,] VarValue = new object[dtResult.Rows.Count, 15];

for (int i = 0; i < dtResult.Rows.Count;i++ )
{
VarValue[i, 0] = i;
VarValue[i, 1] = dtResult.Rows[i]["ProductName"].ToString();
VarValue[i, 2] = "";
VarValue[i, 3] = "";
VarValue[i, 4] = dtResult.Rows[i]["RealityQuantity"].ToString();
VarValue[i, 5] = "";
VarValue[i, 6] = dtResult.Rows[i]["EstimatePrice"].ToString();
VarValue[i, 7] = "";
VarValue[i, 8] = dtResult.Rows[i]["Application"].ToString();
VarValue[i, 9] = "";
VarValue[i, 10] = dtResult.Rows[i]["PaymentPattern"].ToString();
VarValue[i, 11] = "";
VarValue[i, 12] = dtResult.Rows[i]["Remarks"].ToString();
VarValue[i, 13] = "";
VarValue[i, 14] = "";
VarValue[i, 15] = "";
}

// excelWS.Range("A7:U" & CStr(REC.RowCount + 6))._Default = VB6.CopyArray(VarValue)

写了个 2维数组，来保存 数据集的行数，excel的列数，
往数组里面放数据
最后注释的那句是 原先VB 写的 从(A7：U deresult.rows.Count + 6 )开始往excel里面插入数组的数据，这用C# 怎么实现？ Excel C#
[解决办法]
使用NOIP简单快捷，及其简单，资源占用小，不用关心资源释放问题
[解决办法]
Excel.Application excApp = new Excel.ApplicationClass();
Excel.Workbook wb = excApp.Workbooks.Add(true);
Excel.Worksheet ws = wb.ActiveSheet as Excel.Worksheet;
object[,] VarValue = (object[,])ws.get_Range(ws.Cells[1, 1], ws.Cells[dtResult.Rows.Count, 15]).Value2;
for (int i = 0; i < dtResult.Rows.Count;i++ )
{
VarValue[i+1,1]="";
VarValue[i+1,2]="";
...
...
}
ws.get_Range(ws.Cells[1, 1], ws.Cells[dtResult.Rows.Count, 15]).Value2=VarValue;

//保存excel