通过excel模板文件根据数据库数据修改其中的单元格数据

        /// <summary>
        /// 根据文件模板生成excel
        /// </summary> 
        /// <param name="dttew">利润表_月报</param> 
        /// <param name="opetes">文件名</param>
        /// <param name="queryKey">资产负债表{税款所属期起-税款所属期止}</param>
        public void LeadExcelone(DataTable dttew, string opetes, string[] queryKey)
        {
            string filePath = Server.MapPath("/FilePath/" + "报表申报官方模板.xls");//项目内置文件模板地址
            using (var file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
            {
                MemoryStream ms = new MemoryStream();
                var hssfworkbook = new HSSFWorkbook(file);   
                var sheet2 = hssfworkbook.GetSheetAt(1);//获取文件第二个sheet
                row3 = 4;
                if (dttew != null && dttew.Rows.Count > 0)
                {
                    for (int i = 0; i < dttew.Rows.Count; i++)
                    {
                        sheet2.GetRow(row3).GetCell(2).SetCellValue(dttew.Rows[i]["F_BalanceCP"].ToString() == "" ? "0.00" : dttew.Rows[i]["F_BalanceCP"].ToString());
                        sheet2.GetRow(row3).GetCell(3).SetCellValue(dttew.Rows[i]["F_BalanceCY"].ToString() == "" ? "0.00" : dttew.Rows[i]["F_BalanceCY"].ToString());
                        row3++;
                    }
                }  
                hssfworkbook.Write(ms);
                System.Web.HttpContext.Current.Response.Clear();
                System.Web.HttpContext.Current.Response.ClearHeaders();
                System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
                System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel.sheet.binary.macroEnabled.12";
                System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename="+ opetes + ".xls");
                System.Web.HttpContext.Current.Response.BinaryWrite(ms.ToArray());
                //清除缓存  
                System.Web.HttpContext.Current.Response.Flush();
                System.Web.HttpContext.Current.Response.End();
                //关闭缓冲区  
                ms.Close();
            }
        }