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

2012-01-04 17:37 105人阅读 评论(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    

注：需要添加Microsoft.Office.Interop.Word.dll引用