近期一段时间正好在做winform导出Excel报表的问题，，学习了一下C#操作Excel的一些方法（如：向Excel中插入图片；删除Excel指定sheet中的某行或某列，在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>模板文件物理路径</param>
        public void Open(string TemplateFilePath)
        {
            //打开对象
            m_objExcel = new Excel.Application();
            m_objExcel.Visible = false;
            m_objExcel.DisplayAlerts = false;

if (m_objExcel.Version != "11.0")
            {
                MessageBox.Show("您的 Excel 版本号不是 11.0 （Office 2003），操作可能会出现故障。");
                m_objExcel.Quit();
                return;
            }

m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
            if (TemplateFilePath.Equals(String.Empty))
            {
                m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
            }
            else
            {
                m_objBook = m_objBooks.Open(TemplateFilePath, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
                  m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
            }
            m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
            m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
            m_objExcel.WorkbookBeforeClose += new Excel.AppEvents_WorkbookBeforeCloseEventHandler(m_objExcel_WorkbookBeforeClose);
        }

private void m_objExcel_WorkbookBeforeClose(Excel.Workbook m_objBooks, ref bool _Cancel)
        {
            MessageBox.Show("保存完成！");
        }