第1个回答 2009-08-19
//引用COM中的 Microsoft.Excel 11.0
string excelFilePath = @"D:\1.xls"; //已经存在的Excel
Excel.Application myExcel = new Excel.ApplicationClass();
string excelFilePath = @"D:\1.xls";
Excel.Application myExcel = new Excel.ApplicationClass();
object oMissing = System.Reflection.Missing.Value;
Excel.Workbook myBook= myExcel.Application.Workbooks.Open(excelFilePath, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
Excel.Worksheet mySheet = (Excel.Worksheet)myBook.Worksheets[1];
mySheet.Cells[5, 5] = "test"; //给excel中的第5行和第5列赋值 表头就是第1行
myBook.Close(true, oMissing, oMissing); // 保存修改后的excel
myExcel.Quit();
或者引用 .net 里的 Microsoft.Office.Excel
string excelFilePath = @"D:\1.xls";
Microsoft.Office.Interop.Excel.ApplicationClass myExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
object oMissing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Workbook myBook = myExcel.Workbooks.Open(excelFilePath, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
Microsoft.Office.Interop.Excel.Worksheet mysheet = (Microsoft.Office.Interop.Excel.Worksheet)myBook.Worksheets[1];
Microsoft.Office.Interop.Excel.Range r = (Microsoft.Office.Interop.Excel.Range)mysheet.Cells[5, 5];
r.Value2 = "luotest";
myBook.Close(true, oMissing, oMissing);
myExcel.Quit();