C#操作Excel详解

一、添加引用
    添加com组件（Microsoft Office 11.0 Object Library ）命名空间为Microsoft.Office.Interop.Excel
    添加Excel.exe引用默认路径为C:\Program Files\Microsoft Office\OFFICE11\Excel.exe
二、Excel控制类
using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
namespace ExcelOperation
{
    public class ExcelControl
    {
        private Excel.Application m_objExcel = null;
        private Excel.Workbooks m_objBooks = null;
        private Excel._Workbook m_objBook = null;
        private Excel.Sheets m_objSheets = null;
        private Excel._Worksheet m_objSheet = null;
        private Excel.Range m_objRange = null;
        private object m_objOpt = System.Reflection.Missing.Value;
        /// <summary>
        /// 打开没有模板的操作。
        /// </summary>
        public void Open()
        {
            this.Open(String.Empty);
        }
        /// <summary>
        /// 功能：实现Excel应用程序的打开
        /// </summary>
        /// <param name="TemplateFilePath">模板文件物理路径</param>
        public void Open(string TemplateFilePath)
      &