int[,] b = new int[10000, 1000];
private void button1_Click(object sender, RibbonControlEventArgs e)
{
Excel.Range a;
Excel.Worksheet ws =(Excel .Worksheet ) Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet;
a = ws.get_Range(ws .Cells [1,1],ws.Cells [10000,1000]);
DateTime aa = DateTime.Now;
a.Value2 = b; ws.Cells .Columns .AutoFit ();
DateTime bb = DateTime.Now;
TimeSpan cc = bb - aa;
MessageBox.Show(cc.ToString());
}显示 00:00:56.0625000
要是每个值 都编辑完了再... 而且过程复杂的话...
private void button1_Click(object sender, RibbonControlEventArgs e)
{
Excel.Range a;
Excel.Worksheet ws =(Excel .Worksheet ) Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet;
a = ws.get_Range(ws .Cells [1,1],ws.Cells [10000,1000]);
DateTime aa = DateTime.Now;
a.Value2 = b; ws.Cells .Columns .AutoFit ();
DateTime bb = DateTime.Now;
TimeSpan cc = bb - aa;
MessageBox.Show(cc.ToString());
}显示 00:00:56.0625000
要是每个值 都编辑完了再... 而且过程复杂的话...
我是想问 除了二维数组的方法 还有没有更快的 插入方式?
更快的 把数据 写到 excel里 让操作这张表的我!感觉不到等待...