学步园

using System.Reflection;
using System.Runtime.InteropServices;
using Excel = Microsoft.Office.Interop.Excel;

//操作Excel的变量
            Excel.Application xApp = null;
            Excel.Worksheet xSheet = null;
            Excel.Workbook xBook = null;
            Excel.Range rng2 = null;
//创建Application对象
                xApp = new Excel.ApplicationClass();
                xApp.Visible = false;
                //得到WorkBook对象, 可以用两种方式之一: 下面的是打开已有的文件
                xBook = xApp.Workbooks._Open(m_strFilename,
                Missing.Value, Missing.Value, Missing.Value, Missing.Value
                , Missing.Value, Missing.Value, Missing.Value, Missing.Value
                , Missing.Value, Missing.Value, Missing.Value, Missing.Value);

                //获取第一个表单
                xSheet = (Excel.Worksheet)xBook.Sheets[1];
                //获取列数
                m_nColumn_Count = xSheet.UsedRange.Columns.Count;
                //获取行数
                m_nRow_Count = xSheet.UsedRange.Rows.Count;
//读取，通过Range对象，得到单元格 ，行列都从1开始
                    rng2 = (Excel.Range)xSheet.Cells[i, j];

xSheet = null;
                xBook = null;
                if (null != xApp)
                {
                    xApp.Quit(); //这一句是非常重要的，否则Excel对象不能从内存中退出
                    xApp = null;
                }