C#快速操作Excel

// 创建 Excel
Excel.Application _excelApp = new Excel.Application();

// Missing.Value 在System.Reflection 命名空间中
// Missing.Value 还可以改成Excel模版
Excel.Workbook _excelWorkbook = _excelApp.Workbooks.Add(Missing.Value);

// 获取sheet
Excel.Worksheet _excelSheet = (Excel.Worksheet)(_excelWorkbook.ActiveSheet);

// 要填充的内容
string[,] sTbArray = new string[100, 5];

// 对内容sTbArray进行赋值 

// 获取范围并且赋值 
_excelSheet.get_Range(_excelSheet.Cells[1, 1],
                      _excelSheet.Cells[100, 5]).Value = ((object)(sTbArray)); 

// 不显示询问对话框
_excelApp.DisplayAlerts = false;

// 保存
_excelWorkbook.SaveAs(sServePath,
                      Missing.Value,
                      Missing.Value,
                      Missing.Value,
                      Missing.Value,
                      Missing.Value,
                      Excel.XlSaveAsAccessMode.xlNoChange,
                      Missing.Value,
                      Missing.Value,
                      Missing.Value,
                      Missing.Value);  
// 退出
_excelApp.Quit();