首页 > 代码库 > 操作word文档 添加一个table (书签方式)

操作word文档 添加一个table (书签方式)

1.添加一个table 显示成问答两列

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Aspose.Words;
using TJSupervisor.ModulePluginsHandler.Business.Service;

namespace HY.DevelopmentWeb.ProjectWeb.Page.InquiryRecordPrint
{
    public partial class InquiryRecordWord : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                int CaseId;
                string EmpId;
                if (Request.QueryString["Id"] != null)
                {
                    CaseId = Convert.ToInt32(Request.QueryString["Id"].ToString());
                    EmpId = Request.QueryString["EmpId"].ToString();
                }
                else
                {
                    return;
                }
                InquiryRecordPrintService cs = new InquiryRecordPrintService();

                DataSet ds = new DataSet();
                ds = cs.GetInquiryRecordPrint(CaseId, EmpId);
                string tmppath = Server.MapPath("~/Data/InquiryRecordPrint.doc");
                string dataDir = Server.MapPath("~/Data/");
                Document doc = new Document(tmppath); //载入模板
                DocumentBuilder builder = new DocumentBuilder(doc);

                doc.Range.Replace("{{InquiriedEmpName}}", ds.Tables[0].Rows[0]["InquiriedEmpName"].ToString(), false, false);
                doc.Range.Replace("{{Gender}}", ds.Tables[0].Rows[0]["Gender"].ToString(), false, false);
                doc.Range.Replace("{{Marriage}}", ds.Tables[0].Rows[0]["Marriage"].ToString(), false, false);
                doc.Range.Replace("{{OrgName}}", ds.Tables[0].Rows[0]["OrgName"].ToString(), false, false);
                doc.Range.Replace("{{EmpJob}}", ds.Tables[0].Rows[0]["EmpJob"].ToString(), false, false);
                doc.Range.Replace("{{EntryTime}}", ds.Tables[0].Rows[0]["EmployedDate"].ToString(), false, false);
                doc.Range.Replace("{{PermanentAddr}}", ds.Tables[0].Rows[0]["PermanentAddr"].ToString(), false, false);
                doc.Range.Replace("{{ResidenceAddr}}", ds.Tables[0].Rows[0]["ResidenceAddr"].ToString(), false, false);
                doc.Range.Replace("{{ContactTel}}", ds.Tables[0].Rows[0]["ContactTel"].ToString(), false, false);
                doc.Range.Replace("{{IdentityNo}}", ds.Tables[0].Rows[0]["IdentityNo"].ToString(), false, false);
                doc.Range.Replace("{{InquiryDateBegin}}", ds.Tables[0].Rows[0]["InquiryDateBegin"].ToString(), false, false);
                doc.Range.Replace("{{InquiryDateEnd}}", ds.Tables[0].Rows[0]["InquiryDateEnd"].ToString(), false, false);
                doc.Range.Replace("{{InquiryPlace}}", ds.Tables[0].Rows[0]["InquiryPlace"].ToString(), false, false);
                doc.Range.Replace("{{InquiryItems}}", ds.Tables[0].Rows[0]["InquiryItems"].ToString(), false, false);

                //Insert some table  
                bool isbool = builder.MoveToBookmark("Table");
                if (isbool)
                {
                    builder.StartTable();
                    for (int i = 0; i < (ds.Tables[1].Rows.Count * 2); i++)
                    {
                        
                        builder.InsertCell(); //动态添加列
                        builder.Font.Name = "微软雅黑";
                        builder.Font.Size = 10;
                        builder.Bold = false;
                        builder.CellFormat.Width = 800;
                        builder.CellFormat.Borders.Right.Color = System.Drawing.Color.White;//改变左右边框为白色
                        builder.CellFormat.Borders.Left.Color = System.Drawing.Color.White;
                        
                        if (i % 2 == 0)
                        {
                            builder.Write("问(" + ((i / 2) + 1).ToString() + ")" + ds.Tables[1].Rows[(i / 2)]["Question"].ToString());
                        }
                        else
                        {
                            builder.Write("答(" + (((i - 1) / 2) + 1).ToString() + ")" + ds.Tables[1].Rows[((i - 1) / 2)]["Answer"].ToString());
                        }
                        builder.EndRow();
                    }
                    builder.EndTable();
                }

                string fullName = "InquiryRecordPrint_" + System.DateTime.Now.Millisecond.ToString();
                //save word
                doc.Save(Response, "询问笔录_" + ds.Tables[0].Rows[0]["InquiryItems"].ToString(), ContentDisposition.Attachment, new Aspose.Words.Saving.DocSaveOptions(SaveFormat.Doc));              
                Context.Response.Write("{success:‘true‘,fullName:‘" + fullName + "‘}");
            }
            catch (Exception ex)
            {
                Context.Response.Write("{success:‘false‘,fullName:‘" + ex.Message + "‘}");
            }
        }
    }
}

 

 

2.靠查出来的数据循环table的行

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Aspose.Words;
using TJSupervisor.ModulePluginsHandler.Business.Service;

namespace HY.DevelopmentWeb.ProjectWeb.Page.CaseReportPrint
{
    public partial class CaseReportWord : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                int CaseId;
                if (Request.QueryString["Id"] != null)
                {
                    CaseId = Convert.ToInt32(Request.QueryString["Id"].ToString());
                }
                else
                {
                    return;
                }
                CaseReportPrintService cs = new CaseReportPrintService();

                DataSet ds = new DataSet();
                ds = cs.GetPrintCaseInfo(CaseId);
                string tmppath = Server.MapPath("~/Data/CaseReport.docx");
                string dataDir = Server.MapPath("~/Data/");
                Document doc = new Document(tmppath); //载入模板
                DocumentBuilder builder = new DocumentBuilder(doc);
                //for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                //{

                //    DataRow dr = ds.Tables[0].Rows[i];
                //    doc.Range.Replace("{{replace}}", dr["EmpName"].ToString() + dr["gender"].ToString() + dr["Entrytime"].ToString() + "入职途家,现任" + dr["job"].ToString(), false, false); // {{EmpName}},{{gender}},{{Entrytime}}入职途家,现任{{job}}。
                //    //doc.Range.Replace("{{EmpName}}", dr["EmpName"].ToString(), false, false);
                //    //doc.Range.Replace("{{gender}}", dr["gender"].ToString(), false, false);
                //    //doc.Range.Replace("{{Entrytime}}", dr["Entrytime"].ToString(), false, false);
                //    //doc.Range.Replace("{{job}}", dr["job"].ToString(), false, false);

                //}

                  bool isbool = builder.MoveToBookmark("Table");
                  if (isbool)
                  {
                      builder.StartTable();
                      for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                      {

                          builder.InsertCell(); //动态添加列
                          builder.Font.Name = "宋体";
                          builder.Font.Size = 12;
                          builder.Bold = false;
                          builder.CellFormat.Width = 800;
                          builder.CellFormat.Borders.Right.Color = System.Drawing.Color.White;//改变左右边框为白色
                          builder.CellFormat.Borders.Left.Color = System.Drawing.Color.White;
                          builder.CellFormat.Borders.Top.Color = System.Drawing.Color.White;//改变左右边框为白色
                          builder.CellFormat.Borders.Bottom.Color = System.Drawing.Color.White;

                          //doc.Range.Replace("{{replace}}", ds.Tables[0].Rows[i]["EmpName"].ToString() + ds.Tables[0].Rows[i]["gender"].ToString() + ds.Tables[0].Rows[i]["Entrytime"].ToString() + "入职途家,现任" + ds.Tables[0].Rows[i]["job"].ToString(), false, false); // {{EmpName}},{{gender}},{{Entrytime}}入职途家,现任{{job}}。
                          builder.Write(ds.Tables[0].Rows[i]["EmpName"].ToString() +"," +ds.Tables[0].Rows[i]["gender"].ToString()+"," + ds.Tables[0].Rows[i]["Entrytime"].ToString() + "入职途家,现任" + ds.Tables[0].Rows[i]["job"].ToString()); // {{EmpName}},{{gender}},{{Entrytime}}入职途家,现任{{job}}。
                          builder.EndRow();
                      }
                      builder.EndTable();
                  }
                doc.Range.Replace("{{RegisterSN}}", ds.Tables[0].Rows[0]["RegisterSN"].ToString(), false, false);
                doc.Range.Replace("{{Name}}", ds.Tables[0].Rows[0]["Name"].ToString(), false, false);
                doc.Range.Replace("{{OccurDateBegin}}", ds.Tables[0].Rows[0]["OccurDateBegin"].ToString(), false, false);
                doc.Range.Replace("{{OccurDateEnd}}", ds.Tables[0].Rows[0]["OccurDateEnd"].ToString(), false, false);
                doc.Range.Replace("{{OccurPlace}}", ds.Tables[0].Rows[0]["OccurPlace"].ToString(), false, false);
                doc.Range.Replace("{{OccurOrgName}}", ds.Tables[0].Rows[0]["OccurOrgName"].ToString(), false, false);
                doc.Range.Replace("{{InspectorEmpName}}", ds.Tables[0].Rows[0]["InspectorEmpName"].ToString(), false, false);
                doc.Range.Replace("{{Data04}}", ds.Tables[0].Rows[0]["job"].ToString(), false, false);
                doc.Range.Replace("{{JointEmpNames}}", ds.Tables[0].Rows[0]["JointEmpNames"].ToString(), false, false);
                doc.Range.Replace("{{RegisterDate}}", ds.Tables[0].Rows[0]["RegisterDate"].ToString(), false, false);
                doc.Range.Replace("{{AcceptDate}}", ds.Tables[0].Rows[0]["AcceptDate"].ToString(), false, false);
                doc.Range.Replace("{{Channel}}", ds.Tables[0].Rows[0]["Channel"].ToString(), false, false);
              
                doc.Range.Replace("{{Step}}", ds.Tables[0].Rows[0]["Step"].ToString(), false, false);
                doc.Range.Replace("{{Discovery}}", ds.Tables[0].Rows[0]["Discovery"].ToString(), false, false);
                doc.Range.Replace("{{Conclusion}}", ds.Tables[0].Rows[0]["Conclusion"].ToString(), false, false);
                doc.Range.Replace("{{Suggestion}}", ds.Tables[0].Rows[0]["Suggestion"].ToString(), false, false);
                doc.Range.Replace("{{DateTime}}", ds.Tables[0].Rows[0]["DateTime"].ToString(), false, false);

                string fullName = "CaseReportWord_" + System.DateTime.Now.Millisecond.ToString();
                //save word
                doc.Save(Response, "调查报告_" + ds.Tables[0].Rows[0]["Name"].ToString(),ContentDisposition.Attachment, new Aspose.Words.Saving.DocSaveOptions(SaveFormat.Doc));
                Context.Response.Write("{success:‘true‘,fullName:‘" + fullName + "‘}");
            }
            catch (Exception ex)
            {
                Context.Response.Write("{success:‘false‘,fullName:‘" + ex.Message + "‘}");
            }
        }
    }
}

操作word文档 添加一个table (书签方式)