如下形式的表格我们可以用如下代码进行矩阵填充
A B C D E
+--------------+
1|1 | 1 | 1 | 1 |
+--------------+
2|1 | 1 | 1 | 1 |
+--------------+
3|1 | 1 | 1 | 1 |
+--------------+
4|1 | 1 | 1 | 1 |
+--------------+
protected void Button2_Click(object sender, EventArgs e)
{
Excel.Application xApp = new Excel.ApplicationClass();
xApp.DisplayAlerts = false; //屏蔽alert
xApp.Visible = false;
Excel.Workbook xBook = xApp.Workbooks._Open(@"C:\A.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Excel.Worksheet xSheet = (Excel.Worksheet)xBook.Sheets[1];
Excel.Range rng1 = xSheet.get_Range("A1", Type.Missing);
//写入数据
object[,] objData = new Object[4, 4];
objData[0, 0] = 1;
objData[1, 0] = 1;
objData[2, 0] = 1;
objData[3, 0] = 1;
objData[0, 1] = 1;
objData[1, 1] = 1;
objData[2, 1] = 1;
objData[3, 1] = 1;
objData[0, 2] = 1;
objData[1, 2] = 1;
&a