智者樂山山如畫, 仁者樂水水無涯。 從從容容一盃酒, 平平淡淡一盞茶。 細雨朦朧小石橋, 春風盪漾小竹筏。 夜無明月花獨舞, 腹有詩書气自華。 吾生有崖,也知無崖,以有崖逐無崖,殆也

Aspose.Words 根据HTML table 生成Word模版,并自动生成书签与域

需要引用 Aspose.Words 请自行下载

先准备一个HTML 文件,文件内容参考下面

<table border="1" cellspacing="0" style="margin: 0 auto; width: 90%; border-color: #000; text-align: center;" class="layui-table">
    <colgroup>
        <col style="width: 20%; text-align: center; vertical-align: middle">
        <col style="width: 20%;">
        <col style="width: 20%;">
        <col style="width: 20%;">
        <col style="width: 20%;">
    </colgroup>
    <tbody>
        <tr>
            <td rowspan="6"><span>申请单位基本情况</span></td>
            <td><span>项目申报单位</span></td>
            <td colspan="3">
                <input type="text" name="4000" id="4000" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>单位地址</span></td>
            <td colspan="3">
                <input type="text" name="4001" id="4001" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>注册资本(万元)</span></td>
            <td>
                <input type="text" name="4002" id="4002" class="layui-input"></td>
            <td><span>企业社会信用代码</span></td>
            <td>
                <input type="text" name="4003" id="4003" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>对外贸易经营者备案表编号</span></td>
            <td>
                <input type="text" name="4004" id="4004" class="layui-input">
            </td>
            <td>
                <input type="text" name="4005" id="4005" class="layui-input" style="width: 50px; display: inline-block">
                <span>年出口额</span><span>(万美元)</span></td>
            <td>
                <input type="text" name="4006" id="4006" class="layui-input">
            </td>
        </tr>
        <tr>
            <td>
                <span>法定代表人</span></td>
            <td>
                <input type="text" name="4007" id="4007" class="layui-input">
            </td>
            <td><span>联系电话(手机)</span></td>
            <td>
                <input type="text" name="4008" id="4008" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>联 系 人</span></td>
            <td>
                <input type="text" name="4009" id="4009" class="layui-input">
            </td>
            <td><span>联系电话(手机)</span></td>
            <td>
                <input type="text" name="4010" id="4010" class="layui-input">
            </td>
        </tr>
        <tr>
            <td rowspan="2"><span>上一年企业基本情况</span></td>
            <td><span>企业总资产(万元)</span></td>
            <td>
                <input type="text" name="4011" id="4011" class="layui-input">
            </td>
            <td><span>营业收入(万元)</span></td>
            <td>
                <input type="text" name="4012" id="4012" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>入库税金(万元)</span></td>
            <td>
                <input type="text" name="4013" id="4013" class="layui-input">
            </td>
            <td><span>财政补助(万元)</span></td>
            <td>
                <input type="text" name="4014" id="4014" class="layui-input">
            </td>
        </tr>
        <tr>
            <td rowspan="9"><span>项目基本情况</span></td>
            <td><span>项目类别</span></td>
            <td>
                <select name="4015" id="4015">
                    <option value="类别一">类别一</option>
                    <option value="类别二">类别二</option>
                    <option value="类别三">类别三</option>
                </select>
               
            </td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td><span>项目名称</span></td>
            <td colspan="3">
                <input type="text" name="4016" id="4016" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>投保保险公司名称</span></td>
            <td colspan="3">
                <input type="text" name="4017" id="4017" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>投保国家及地区</span></td>
            <td colspan="3">
                <input type="text" name="4018" id="4018" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>投保金额(万元)</span></td>
            <td>
                <input type="text" name="4019" id="4019" class="layui-input">
            </td>
            <td><span>申请补助(万元)</span></td>
            <td>
                <input type="text" name="4020" id="4020" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>货物出险金额(万美元)</span></td>
            <td>
                <input type="text" name="4021" id="4021" class="layui-input">
            </td>
            <td><span>赔付金额(万元)</span></td>
            <td>
                <input type="text" name="4022" id="4022" class="layui-input">
            </td>
        </tr>
        <tr>
            <td><span>项目所属区</span></td>
            <td>
                <select name="4023" id="4023">
                    <option value="西湖区">西湖区</option>
                    <option value="上城区">上城区</option>
                    <option value="下城区">下城区</option>
                </select>
                
            </td>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td rowspan="2"><span>附件</span></td>
            <td><span>申报材料(必须提供)</span></td>
            <td valign="top" colspan="2"><span></span></td>
        </tr>
        <tr>
            <td><span>其他申报证明材料</span></td>
            <td valign="top" colspan="2"></td>
        </tr>
    </tbody>
</table>

 

然后后台读取这个HTML 

/// <summary>
        /// 按照HTML生成WORD模版
        /// 输入框Input,选择框Select都替换为 域
        /// </summary>
        protected void CreateWordSetFiled()
        {
            string sp = Server.MapPath(_savePath);
            if (!System.IO.Directory.Exists(sp))
            {
                System.IO.Directory.CreateDirectory(sp);
            }

            _templateHtmlPath = Server.MapPath(_templateHtmlPath);//HTML文件路径
            string f = Guid.NewGuid().ToString("N") + ".doc";
            string copyto = sp + f;//生成文件的保存地址
            //读取HTML
            using (StreamReader reader = new StreamReader(_templateHtmlPath))
            {
                string html = reader.ReadToEnd();
                List<string> list = new List<string>();
                html = html.Replace("\r\n", "");
                html = ReplaceHtml(html, ref list);//处理HTML

                Aspose.Words.Document wordDoc = new Aspose.Words.Document();
                DocumentBuilder builder = new DocumentBuilder(wordDoc);
                builder.InsertHtml(html);
                //获取Table 并循环行与列
                NodeCollection allTables = wordDoc.GetChildNodes(NodeType.Table, true);
                for (int t = 0; t < allTables.Count; t++)
                {
                    Aspose.Words.Tables.Table table = (Aspose.Words.Tables.Table)allTables[t];
                    NodeCollection rows = table.GetChildNodes(NodeType.Row, true);
                    for (int r = 0; r < rows.Count; r++)
                    {
                        NodeCollection cell = ((Row)rows[r]).GetChildNodes(NodeType.Cell, true);
                        for (int c = 0; c < cell.Count; c++)
                        {
                            foreach (string s in list)
                            {
                                if (cell[c].ToString(SaveFormat.Text).Trim().StartsWith(s))
                                {
                                    builder.MoveToCell(t, r, c, 0);
                                    Aspose.Words.Replacing.FindReplaceOptions opt = new Aspose.Words.Replacing.FindReplaceOptions();
                                    cell[c].Range.Replace(s, "", opt);//清除文本
                                    string fl = string.Format(" MERGEFIELD {0} ", s);
                                    builder.InsertField(fl);//插入域
                                    /*
                                    builder.StartBookmark(s); //插入书签
                                    builder.Write(s);
                                    builder.EndBookmark(s);
                                     * */
                                }
                            }
                        }
                    }
                }

               
                //wordDoc.MailMerge.DeleteFields(); //清空域
                wordDoc.Range.Bookmarks.Clear(); //清空书签
                wordDoc.Save(copyto, SaveFormat.Doc);
            }
        }

        /// <summary>
        /// 将HTML里的 控件 换成 标签,并返回替换好的HTML
        /// </summary>
        /// <param name="html"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        protected string ReplaceHtml(string html,ref List<string> list)
        {
            MatchCollection mc = Regex.Matches(html, "<input?\\s+.*?id=[\"']?([^\"'\\s>]+)[\"']?[^>]*>");
            MatchCollection mc2 = Regex.Matches(html, "<select?\\s+.*?id=[\"']?([^\"'\\s>]+)[\"']?[^>]*>.*?</select>");
            foreach (Match m in mc)
            {
                html = html.Replace(m.Value, "s" + m.Groups[1].Value);
                list.Add("s" + m.Groups[1].Value);
            }
            foreach (Match m in mc2)
            {
                html = html.Replace(m.Value, "s" + m.Groups[1].Value);
                list.Add("s" + m.Groups[1].Value);
            }
            return html;
        }

 

生成模版后,可以接收第一个HTML提交的数据,并写入WORD模版中

protected void Save2()
        {
            string json = Request["json"];

            DataTable dt = GetData(json);

            string sp = Server.MapPath(_savePath);
            if (!System.IO.Directory.Exists(sp))
            {
                System.IO.Directory.CreateDirectory(sp);
            }

            _templatePath = Server.MapPath(_templatePath);
            string f = Guid.NewGuid().ToString("N") + ".pdf";
            string copyto = sp + f;

            File.Copy(_templatePath.ToString(), copyto, true); //将文件复制到结果文档中
            Aspose.Words.Document doc = new Aspose.Words.Document(copyto);
            Aspose.Words.DocumentBuilder builder = new DocumentBuilder(doc);

            foreach (DataColumn c in dt.Columns)
            {
                string field = string.Format("s{0}", c.ColumnName);
                while (builder.MoveToMergeField(field))
                {
                    builder.Write(dt.Rows[0][c.ColumnName].ToString());
                }
            }
            /*
            string error = string.Empty;
            List<string> list = GetFileds(doc, out error);
            foreach (string s in list)
            {
                while (builder.MoveToMergeField(s))
                {
                    builder.Write("");
                }
            }
             * */
            doc.MailMerge.DeleteFields(); //清空未使用的域
            doc.Save(copyto, Aspose.Words.SaveFormat.Pdf);

            //MemoryStream docStream = new MemoryStream();
            //doc.Save(docStream, Aspose.Words.SaveFormat.Pdf);

            //Aspose.Pdf.Document pdfDocument = new Aspose.Pdf.Document(docStream);
            //pdfDocument.Save(docStream);



            /*
            Response.ContentType = "application/msword";
            Response.AddHeader("content-disposition", "attachment;  filename=" + info.itemname + ".pdf");
            Response.BinaryWrite(docStream.ToArray());
            Response.End();
             * */
        }


        protected DataTable GetData(string json)
        {
            //Newtonsoft.Json.Linq.JArray array = Newtonsoft.Json.JsonConvert.DeserializeObject(json) as JArray;
            JObject objdata = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(json);
            StringBuilder columns = new StringBuilder();
            DataTable table = new DataTable();
            JObject objColumns = objdata;// array[0] as JObject;
            //构造表头
            foreach (JToken jkon in objColumns.AsEnumerable<JToken>())
            {
                string name = ((JProperty)(jkon)).Name;
                columns.Append(name + ",");
                table.Columns.Add(name);
            }

            DataRow row = table.NewRow();
            JObject obj = objdata;
            foreach (JToken jkon in obj.AsEnumerable<JToken>())
            {
                string name = ((JProperty)(jkon)).Name;
                string value = ((JProperty)(jkon)).Value.ToString();
                row[name] = value;
            }
            table.Rows.Add(row);

            return table;
        }

 

使用书签

//使用书签替换
        protected void Save()
        {
            string json = Request["json"];

            DataTable dt = GetData(json);

            string sp = Server.MapPath(_savePath);
            if (!System.IO.Directory.Exists(sp))
            {
                System.IO.Directory.CreateDirectory(sp);
            }

            _templatePath = Server.MapPath(_templatePath);
            string f = Guid.NewGuid().ToString("N") + ".doc";
            string copyto = sp + f;

            File.Copy(_templatePath.ToString(), copyto, true); //将文件复制到结果文档中
            Aspose.Words.Document doc = new Aspose.Words.Document(copyto);
            Aspose.Words.DocumentBuilder builder = new DocumentBuilder(doc);
            foreach (Bookmark bm in doc.Range.Bookmarks)
            {
                if (dt.Columns.Contains(bm.Name.TrimStart('s')))
                {
                    builder.MoveToBookmark(bm.Name);
                    bm.Text = dt.Rows[0][bm.Name.TrimStart('s')].ToString();
                }
            }
            doc.Save(copyto, Aspose.Words.SaveFormat.Doc);

        }

 

posted @ 2020-03-22 16:12  後生哥哥  阅读(1632)  评论(0编辑  收藏  举报
智者樂山山如畫, 仁者樂水水無涯。 從從容容一盃酒, 平平淡淡一盞茶。 細雨朦朧小石橋, 春風盪漾小竹筏。 夜無明月花獨舞, 腹有詩書气自華。 吾生有崖,也知無崖,以有崖逐無崖,殆也