aspose导出word
来源:互联网 发布:决战紫禁之巅 知乎 编辑:程序博客网 时间:2024/05/16 18:54
protected void LinkButton1_Click(object sender, EventArgs e)
{
#region 单个标签替换值
//string tmppath = Server.MapPath("~/template.doc");
//Document doc = new Document(tmppath); //载入模板
//if (doc.Range.Bookmarks["name"] != null)
//{
// Bookmark mark = doc.Range.Bookmarks["name"];
// mark.Text = "张三公司";
//}
//doc.Save("demo.doc", SaveFormat.Doc, SaveType.OpenInWord, Response);
#endregion
/////////////////
#region
string tmppath = Server.MapPath("~/template.doc");
Document doc = new Document(tmppath); //载入模板
DocumentBuilder builder = new DocumentBuilder(doc);
DocumentBuilder builder2 = new DocumentBuilder(doc);
DataTable products = DBaseClass.db.GetSqlStrTable("select username,userid from tsys_user"); ; //数据源
int count = 0;
//记录要显示多少列
for (var i = 0; i < products.Columns.Count; i++)
{
if (doc.Range.Bookmarks[products.Columns[i].ColumnName.Trim()] != null)
{
Bookmark mark = doc.Range.Bookmarks[products.Columns[i].ColumnName.Trim()];
mark.Text = "";
count++;
}
}
System.Collections.Generic.List<string> listcolumn = new System.Collections.Generic.List<string>(count);
for (var i = 0; i < count; i++)
{
builder.MoveToCell(0, 0, i, 0); //移动单元格
if (builder.CurrentNode.NodeType == NodeType.BookmarkStart)
{
listcolumn.Add((builder.CurrentNode as BookmarkStart).Name);
}
}
double width = builder.CellFormat.Width;//获取单元格宽度
builder.MoveToBookmark("table"); //开始添加值
for (var m = 0; m < products.Rows.Count; m++)
{
for (var i = 0; i < listcolumn.Count; i++)
{
builder.InsertCell(); // 添加一个单元格
builder.CellFormat.Borders.LineWidth = 1;
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.Width = width;
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None;
builder.Write(products.Rows[m][listcolumn[i]].ToString());
}
builder.EndRow();
}
doc.Range.Bookmarks["table"].Text = ""; // 清掉标示
doc.Save("baojiadan.doc", SaveFormat.Doc, SaveType.OpenInWord, Response);
#endregion
}
图片是模板的内容
【】是用的标签
【】用户名 【】 性别
【标签table】
合并单元格
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.First;
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.Previous;
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None;
builder.InsertCell(); // 添加一个单元格
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.LineWidth = 1;
builder.Font.Size = 12;
builder.Font.Bold = true;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.First;
builder.CellFormat.Width = wone;
builder.Write("市区");
builder.InsertCell(); // 添加一个单元格
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.LineWidth = 1;
builder.Font.Size = 12;
builder.Font.Bold = false;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.Previous;
builder.CellFormat.Width = wone;
builder.CellFormat.Shading.BackgroundPatternColor = othercolor;
builder.Write("");
winform下保存
SaveFileDialog s = new SaveFileDialog();
s.DefaultExt = ".doc";
s.FileName = "日报word";
if (s.ShowDialog() != DialogResult.OK)
{
return;
}
doc.Save(s.FileName, SaveFormat.Doc);
- aspose导出word
- aspose导出表格到word
- Aspose word导出word/pdf文件
- 根据word模板导出数据(Aspose.Words)
- 利用Aspose.Words按模板导出Word
- Aspose word导出照片代码实现
- aspose.word根据word模板填充对应信息并导出
- Aspose.Words把DataTable 中的数据导出到word中
- Aspose.Words导出带图片人员信息到Word中
- 利用Aspose.Word控件和Aspose.Cell控件,实现Word文档和Excel文档的模板化导出
- 利用Aspose.Word控件和Aspose.Cell控件,实现Word文档和Excel文档的模板化导出
- Aspose.Words使用word模板中的书签插入图片(导出含有图片的word)
- C#Aspose生成word
- Aspose Word 导入
- ASPOSE.WORD操作
- Aspose Word使用
- Aspose.word设置页眉
- C#Aspose生成word
- 一个yuv转bmp的程序
- 保存的链接
- struts2+ireport(jasperreport)记录
- oracle实验记录 (分析oracle硬解析&软解析&fast soft parse)
- Jquery的api中提供了对元素应用disabled和readonly属性的方法
- aspose导出word
- 列表下拉/上拉刷新:(三)强制刷新
- 什么是依赖注入
- cmd进入指定的目录
- Spring学习笔记
- 用pc发短息
- C语言中的可变参数
- wm手机设置wifi 的IP地址
- 英特尔赵军:核芯显卡是未来发展趋势