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(); / / 獲取或設(shè)置當(dāng)前工作表 / 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; / / 打開一個(gè)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; / / 保存數(shù)據(jù) / public void Save() if (m_Workbook != null) m_Workbook.Save(); / / 關(guān)閉文檔 / / public void Close(bool isSave) this.ClearClipboard(); object obj_Save = isSave; if (m_Workbook != null) m_Workbook.Close(obj_Save, missing, missing); / / 設(shè)置當(dāng)前工作表中某單元格的值 / / / 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); / / 將當(dāng)前工作表中的表格數(shù)據(jù)復(fù)制到剪切板 / 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