C#Excel操作类.doc

using System;using System.Collections.Generic;using System.Text; using Excel = Microsoft.Office.Interop.Excel;using System.Diagnostics;using System.Windows.Forms;namespace OfficeManager public class ExcelClass : IDisposable private Excel._Application m_ExcelApplication = null; private Excel._Workbook m_Workbook = null; public Excel._Worksheet m_Worksheet = null; private object missing = System.Reflection.Missing.Value; public ExcelClass() if (m_ExcelApplication = null) m_ExcelApplication = new Excel.ApplicationClass(); ExcelClass() try if (m_ExcelApplication != null) m_ExcelApplication.Quit(); catch (Exception ex) Debug.Write(ex.ToString(); / / 获取或设置当前工作表 / public int CurrentWorksheetIndex set if (value m_Workbook.Worksheets.Count) throw new Exception(索引超出范围); else object index = value; m_Worksheet = m_Workbook.Worksheetsindex as Excel._Worksheet; / / 打开一个Excel工作薄 / / public void OpenWorkbook(string fileName) m_Workbook = m_ExcelApplication.Workbooks.Open(fileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); if (m_Workbook.Worksheets.Count 0) object index = 1; m_Worksheet = m_Workbook.Worksheetsindex as Excel._Worksheet; / / 保存数据 / public void Save() if (m_Workbook != null) m_Workbook.Save(); / / 关闭文档 / / public void Close(bool isSave) this.ClearClipboard(); object obj_Save = isSave; if (m_Workbook != null) m_Workbook.Close(obj_Save, missing, missing); / / 设置当前工作表中某单元格的值 / / / public void SetCellValue(string cellIndex, object value) if (m_Worksheet != null) object cell1 = cellIndex; Excel.Range range = m_Worksheet.get_Range(cell1, missing); if (range != null) range.Value2 = value; / / 合并单元格 / / / public void Merge(string cellIndex1, string cellIndex2) if (m_Worksheet != null) object cell1 = cellIndex1; object cell2 = cellIndex2; Excel.Range range = m_Worksheet.get_Range(cell1, cell2); range.Merge(true); / / 将当前工作表中的表格数据复制到剪切板 / public void Copy() if (m_Worksheet != null) try m_Worksheet.UsedRange.Select(); catch m_Worksheet.UsedRange.Copy(missing); / / 清空剪切板 / public void ClearClipboard() Clipboard.Clear(); #region IDisposable 成员 public void Dispose() try if (m_ExcelApplication != null) this.Close(false