导出excel调用模版

 //导出方法
        void ExportExcelMethod(object param)
        {
            if (ObsTB.Count < 1)
            {
                MessageBox.Show("没有要导出的数据");
                return;
            }
            Excel.Application objApp = new Excel.Application(); //实例化Excle对象
            if (objApp == null)
            {
                MessageBox.Show("无法创建Excel对象，可能计算机未安装Excel！");
                return;
            }
 
            string path = Invoice.Utils.Validation.AppPath();
            objApp.Workbooks.Add(path + @"Excel/发票使用情况一览表.xls");
 
            Excel.Sheets objSheets = objApp.Worksheets;//实例化sheet工作表的集合
            Excel._Worksheet objSheet;
            objSheet = (Excel._Worksheet)objSheets.get_Item(1);//导出sheet1模板
            objSheet.Name = "发票使用情况一览表";
            objApp.Workbooks[1].SaveCopyAs("C:/ceshi.xls");
            objApp.Workbooks[1].BeforeClose += new Excel.WorkbookEvents_BeforeCloseEventHandler(VMFPHeadQuery_BeforeClose);
             
            //设置表头名称
            objApp.Cells[1, 1] = "发票使用情况一览表";
            //设置数据行的格式边框
            //objApp.get_Range((object)objApp.Cells[1, 1], (object)objApp.Cells[obsTB.Count + 3, 22]).Borders.LineStyle = 1;
            objApp.get_Range((object)objApp.Cells[1, 1], (object)objApp.Cells[1, 22]).Interior.ColorIndex = 2;
            //设置标题字体大小
            objApp.get_Range((object)objApp.Cells[1, 1], (object)objApp.Cells[1, 22]).Font.Size = 18;
            //设置内容字体大小
            objApp.get_Range((object)objApp.Cells[4, 1], (object)objApp.Cells[this.ObsTB.Count + 3, 22]).Font.Size = 10;
 
            //string userid = "  操作员编:" + App.OperationUserID.ToString();
            string username = " 操作员:" + App.OperationUserName.ToString();
            //objApp.Cells[2, 1] = "生成时间：" + DateTime.Now.Year + "年" + DateTime.Now.Month + "月" + DateTime.Now.Day + "日" + userid + username;
            objSheet.PageSetup.RightFooter = "生成时间：" + DateTime.Now.Year + "年" + DateTime.Now.Month + "月" + DateTime.Now.Day + "日"+ username;
            //行列
            int iRowIndex = 0;
            int iColIndex = 0;
            int iRowCount = ObsTB.Count;
            int iColCount = 22;
            //二维数组存放数据
            object[,] objData = new object[iRowCount+1, iColCount];
            int j = 1;
            for (iRowIndex = 0; iRowIndex < iRowCount; iRowIndex++)
            {
                for (iColIndex = 0; iColIndex < iColCount; iColIndex++)
                {
                   if(iColIndex==0)
                       objData[iRowIndex, iColIndex] = j++; 
                   if (iColIndex == 1)
                    objData[iRowIndex, iColIndex] = UtilsConverter.GetPJtypNameByPJtyp(ObsTB[iRowIndex].Pjtype);
                   if (iColIndex == 2)
                       objData[iRowIndex, iColIndex] = ObsTB[iRowIndex].Fptype;
                   if (iColIndex == 3)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Dhp;
                   if (iColIndex == 4)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Fpconde;
                   if (iColIndex == 5)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Fpnum;
                   if (iColIndex == 6)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetPiPeiNameBykjzt(ObsTB[iRowIndex].Status1);
                   if (iColIndex == 7)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetPrintZTNameBykjzt(ObsTB[iRowIndex].Status2);
                   if (iColIndex == 8)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetKJZTNameBykjzt(ObsTB[iRowIndex ].Status3);
                   if (iColIndex == 9)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Oper3;
                   if (iColIndex == 10)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Gentime3;
                   if (iColIndex == 11)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetZFZTNameByzfzt(ObsTB[iRowIndex].Status4);
                   if (iColIndex == 12)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Oper4;
                   if (iColIndex == 13)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Gentime4;
                   if (iColIndex == 14)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetPDZTNameByPdzt(ObsTB[iRowIndex].Status5);
                   if (iColIndex == 15)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Oper5;
                   if (iColIndex == 16)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Gentime5;
                   if (iColIndex == 17)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetJHZTNameByjhzt(ObsTB[iRowIndex].Status6);
                   if (iColIndex == 18)
                       objData[iRowIndex, iColIndex] = UtilsConverter.GetHXZTNameByzfzt(ObsTB[iRowIndex].Status7);
                   if (iColIndex == 19)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Oper7;
                   if (iColIndex == 20)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Gentime7;
                   if (iColIndex == 21)
                       objData[iRowIndex, iColIndex] = "'" + ObsTB[iRowIndex].Bz;
                }
            }
            Excel.Range range;
            range = objSheet.get_Range((object)objApp.Cells[4, 1], (object)objApp.Cells[iRowCount+3, 22]);
            range.Value2 = objData;
           
            objApp.Visible = true;
            objApp.DisplayAlerts = false;
            Print(objApp, objSheet);
           
            GC.Collect();
        }