我可以实现写入,但是不知道怎么能在最后一行插入数据 Excel.Application xApp = new Excel.ApplicationClass(); Excel.Workbook xBook = xApp.Workbooks._Open(@"c:/aa.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 rng3=xSheet.get_Range("C6",Missing.Value);
rng3.Value2="Hello"; xBook.Save(); xSheet=null;
xBook=null;
xApp.Quit();
xApp=null;
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 rng3=xSheet.get_Range("C6",Missing.Value);
rng3.Value2="Hello"; xBook.Save(); xSheet=null;
xBook=null;
xApp.Quit();
xApp=null;
//保存方式一:保存WorkBook
//xBook.SaveAs(@"D:\CData.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value
// ,Excel.XlSaveAsAccessMode.xlNoChange,Missing.Value,Missing.Value,Missing.Value//,Missing.Value,Missing.Value);//保存方式二:保存WorkSheet
//xSheet.SaveAs(@"D:\CData2.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value//,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);//保存方式三
xBook.Save(); xSheet=null;
xBook=null;
xApp.Quit(); //这一句是非常重要的,否则Excel对象不能从内存中退出
xApp=null;