.c# winform Excel模板做报表(完美)

           

using Excel = Microsoft.Office.Interop.Excel;//需要引用命名空间

 private void PrintViewExcel

{           

Excel.Application m_objExcel = null;
            Excel._Workbook m_objBook = null;
            Excel.Sheets m_objSheets = null;
            Excel._Worksheet m_objSheet = null;
            Excel.Range m_objRange = null;
            object m_objOpt = System.Reflection.Missing.Value;

            try
            {
                m_objExcel = new Excel.Application();
                m_objBook = m_objExcel.Workbooks.Open("C:\\Test.xlsx", 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;