由于NPOI暂时没找到书签内容替换功能,所以换用Apose.Word组件.
using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using Aspose.Words;using Aspose.Words.Drawing;namespace WordNPOI{public partial class Form2 : Form{public Form2(){InitializeComponent();}private void Form2_Load(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){try{Utils.ExcelDataTableConverter edc = new Utils.ExcelDataTableConverter("60岁以上人员.xlsx");DataTable dt = edc.ExcelToDataTable("sheet1", true);int rowCount = dt.Rows.Count;int columnCount = dt.Columns.Count;Aspose.Words.Document doc = new Aspose.Words.Document("TEMPLATE.DOCX");Aspose.Words.DocumentBuilder builder = new Aspose.Words.DocumentBuilder(doc);builder.MoveToBookmark("BK001");builder.StartTable();//开始画Tablebuilder.ParagraphFormat.Alignment = ParagraphAlignment.Center; // RowAlignment.Center;string str = string.Empty;builder.RowFormat.Height = 20;//添加列头for (int i = 0; i < columnCount; i++){builder.InsertCell();//Table单元格边框线样式builder.CellFormat.Borders.LineStyle = LineStyle.Single;//Table此单元格宽度builder.CellFormat.Width = 600;//此单元格中内容垂直对齐方式builder.CellFormat.VerticalAlignment = Aspose.Words.Tables.CellVerticalAlignment.Center;builder.CellFormat.HorizontalMerge = Aspose.Words.Tables.CellMerge.None;builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None;//字体大小builder.Font.Size = 10;//是否加粗builder.Bold = true;//向此单元格中添加内容builder.Write(dt.Columns[i].ColumnName);}builder.EndRow();//添加每行数据for (int i = 0; i < rowCount; i++){for (int j = 0; j < columnCount; j++){str = dt.Rows[i][j].ToString();///geovindu/p/4106418.html///wuhuacong/archive//08/30/2662961.html//插入Table单元格builder.InsertCell();//Table单元格边框线样式builder.CellFormat.Borders.LineStyle = LineStyle.Single;//Table此单元格宽度 跟随列头宽度//builder.CellFormat.Width = 500;//此单元格中内容垂直对齐方式builder.CellFormat.VerticalAlignment = Aspose.Words.Tables.CellVerticalAlignment.Center;builder.CellFormat.HorizontalMerge = Aspose.Words.Tables.CellMerge.None;builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None;//字体大小builder.Font.Size = 10;//是否加粗builder.Bold = false;//向此单元格中添加内容builder.Write(str);}//Table行结束builder.EndRow();}builder.EndTable();//doc.Range.Bookmarks["BK001"].Text = ""; // 清掉标示 doc.Range.Bookmarks["BK002"].Text = "标题"; <span style="color:#ff6666;">//替换书签内容</span>//Shape shape = new Shape(doc, ShapeType.Image);//shape.ImageData.SetImage("1.png");//shape.Width = 600;//shape.Height = 400;//shape.HorizontalAlignment = Aspose.Words.Drawing.HorizontalAlignment.Center;if (doc.Range.Bookmarks["BK003"] != null){//builder.InsertNode(shape); //这种图片会把后面的内容盖掉builder.MoveToBookmark("BK003");var img = builder.<span style="color:#ff6666;">InsertImage</span>("1.png");img.Width = 300;img.Height = 300;img.HorizontalAlignment = Aspose.Words.Drawing.HorizontalAlignment.Center;}string saveDocFile = "1.DOCX";doc.Save(saveDocFile);if (MessageBox.Show("保存成功，是否打开文件？", "", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes){System.Diagnostics.Process.Start(saveDocFile);}}catch (Exception ex){MessageBox.Show(ex.Message);return;}}}}
