[C#.复制EXCEL并导入数据库.docxVIP

usingMicrosoft.Office.Interop.Excel;usingSystem.Reflection;using Excel;privatevoidUpdateCE() {//创建Application对象Excel.ApplicationxApp = newExcel.Application();xApp.Visible = true;//得到WorkBook对象, 可以用两种方式之一: 下面的是打开已有的文件Excel.WorkbookxBook = xApp.Workbooks._Open(@F:\new_item\PartInfo--SendToCE+date0+.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);//xBook=xApp.Workbooks.Add(Missing.Value);//新建文件的代码//指定要操作的Sheet，两种方式：Excel.WorksheetxSheet = (Excel.Worksheet)xBook.Sheets[1];//Excel.WorksheetxSheet=(Excel.Worksheet)xApp.ActiveSheet; //读取数据，通过Range对象Excel.Range rng1 = xSheet.get_Range(A1, Type.Missing);Console.WriteLine(rng1.Value2);//读取，通过Range对象，但使用不同的接口得到Range Excel.Range rng2 = (Excel.Range)xSheet.Cells[3, 1];Console.WriteLine(rng2.Value2); //写入数据//Excel.Range rng3 = xSheet.get_Range(C6, Missing.Value);//rng3.Value2 = Hello;//rng3.Interior.ColorIndex = 6; //设置Range的背景色//保存方式一：保存WorkBookxBook.SaveAs(@F:\new_item\PartInfo + date0 + .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(@F:\new_item\PartInfo+date0+.xls, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);//保存方式三//xBook.Save();System.Runtime.InteropServices.Marshal.ReleaseComObject(xSheet);xSheet = null;xBook.Close(false, Missing.Value, Missing.Value);System.Runtime.InteropServices.Marshal.ReleaseComObject(xBook);xBook = null;xApp.Quit(); //这一句是非常重要的，否则Excel对象不能从内存中退出System.Runtime.InteropServices.Marshal.ReleaseComObject(xApp);xApp = null;//DataSet ds1;try {DataSetds = ExcelOperate.ExceleDs(F:/new_item/PartInfo + date0 + .xls);//DataSetds = ExcelOperate.ExceleDs(F:/new_item/test.xls);D