根据模板生成word文件并导出保存到本地

最新推荐文章于 2024-07-26 15:02:22 发布

阿尔法狼

最新推荐文章于 2024-07-26 15:02:22 发布

阅读量3.3k

点赞数

分类专栏： ASP.NET 文章标签： object null string exception application byte

本文链接：https://blog.csdn.net/namespacefeng/article/details/7175863

版权

ASP.NET 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

#region 根据模板生成word文件并导出保存到本地
        Microsoft.Office.Interop.Word._Application appWord = new Microsoft.Office.Interop.Word.ApplicationClass();
        Microsoft.Office.Interop.Word._Document docFile = null;
        try
        {
            appWord.Visible = false;
            object objTrue = true;
            object objFalse = false;
            object objTemplate = Server.MapPath(@"WordModle\\Ftest1.doc");//模板路径
            object objDocType = Microsoft.Office.Interop.Word.WdDocumentType.wdTypeDocument;
            docFile = appWord.Documents.Add(ref objTemplate, ref objFalse, ref objDocType, ref objTrue);
            //第一步生成word文档
            //定义书签变量
            object obDD_GCMC = "GCMC";//姓名
            object obDD_LX = "LX";//性别
            object obDD_FX = "FX";//年龄
            object obDD_ZH = "ZH"; //出生年月
            object obDD_GCSL = "GCSL"; //民族
            object obDD_SGNF = "SGNF"; //籍贯

//第二步读取数据，填充数据集
//SqlDataReader dr = XXXXX;//读取出来的数据集

            //第三步给书签赋值
            //给书签赋值
            docFile.Bookmarks.get_Item(ref obDD_GCMC).Range.Text = ""; //姓名
            docFile.Bookmarks.get_Item(ref obDD_LX).Range.Text = "XXX";
            docFile.Bookmarks.get_Item(ref obDD_FX).Range.Text = "XXX";

            //第四步生成word
            DateTime dt = DateTime.Now;
            object filename = Server.MapPath("WordModle\\") + "表" + "XXX1表" + ".doc";
            object miss = System.Reflection.Missing.Value;
            docFile.SaveAs(ref filename, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss);
            object missingValue = Type.Missing;
            object doNotSaveChanges = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges;
            docFile.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
            appWord.Quit(ref miss, ref miss, ref miss);
            docFile = null;
            appWord = null;
            //第五步生成word
            //以字符流的形式下载文件
            string fileName = "表" + "XXX1表" + ".doc";
            string filePath = Server.MapPath("WordModle//") + fileName;
            FileStream fs = new FileStream(filePath, FileMode.Open);
            byte[] bytes = new byte[(int)fs.Length];
            fs.Read(bytes, 0, bytes.Length);
            fs.Close();
            Response.ContentType = "application/octet-stream";
            //通知浏览器下载文件而不是打开
            Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
            Response.BinaryWrite(bytes);
            Response.Flush();
            Response.End();
        }
        catch (Exception ex)
        {
            //捕捉异常，如果出现异常则清空实例，退出word,同时释放资源
            string aa = e.ToString();
            object miss = System.Reflection.Missing.Value;
            object missingValue = Type.Missing;
            object doNotSaveChanges = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges;
            docFile.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
            appWord.Quit(ref miss, ref miss, ref miss);
            docFile = null;
            appWord = null;
            throw ex;
        }
        #endregion