1。创建Excel Microsoft.Office.Interop.Excel.Application ExcelRS; Microsoft.Office.Interop.Excel.Workbook RSbook; Microsoft.Office.Interop.Excel._Worksheet RSsheet; string excelFile = System.Windows.Forms.Application.StartupPath + @"/temp.xlsx"; ExcelRS = new Microsoft.Office.Interop.Excel.ApplicationClass(); ExcelRS.Visible = false; FileInfo tempxls = new FileInfo(excelFile); //如果文件不存在就创建 if (!tempxls.Exists) { //创建Excel有很多参数和很繁琐,我是照着写的,有很多不明白为什么 Microsoft.Office.Interop.Excel.Workbooks m_objBooks = (Microsoft.Office.Interop.Excel.Workbooks)ExcelRS.Workbooks; RSbook = (Microsoft.Office.Interop.Excel.Workbook)(m_objBooks.Add(miss)); RSbook.SaveAs(excelFile, miss, miss, miss, miss, miss, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss, miss, miss); } else //如果存在就打开 { RSbook = ExcelRS.Workbooks.Open(excelFile, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss); } 2 //添加一个空的工作溥 RSsheet = (Microsoft.Office.Interop.Excel._Worksheet)RSbook.Sheets.Add(miss, miss, miss, miss); //修改名字 RSsheet.Name = sheetName; //或者获取一个 // RSsheet = (Microsoft.Office.Interop.Excel._Worksheet)RSbook.Sheets.get_Item(1); //激活当前工作溥 RSsheet.Activate(); 3 //写入数据 RSsheet.Cells[row, col] = cellStr; 4 //保存并关闭 RSbook.Save(); RSsheet = null; RSbook = null; ExcelRS.Quit(); //这一句是非常重要的,否则Excel对象不能从内存中退出 ExcelRS = null;
C# 操作 Excel文件
最新推荐文章于 2024-07-25 06:45:48 发布