//加载文档
Document doc = new Document(Server.MapPath("~/ExportTemplate/CLAAS/ServiceReport.doc"));
//保存
SetData(doc);
doc.Save(Page.Response, "C010.doc", ContentDisposition.Attachment, null);
doc.Clone();
private void SetData(Document doc)
{
DocumentBuilder builder = new DocumentBuilder(doc);
DataTable products = GetTable(); //数据源
builder.MoveToDocumentEnd();
// 下划线不设置
builder.Font.Underline=Underline.None;
//开始表格
Aspose.Words.Tables.Table table = builder.StartTable();
builder.RowFormat.Alignment = RowAlignment.Center;
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
List<string> listcolumn = new List<string>(products.Columns.Count);
for (var i = 0; i < products.Columns.Count; i++)
{
listcolumn.Add(products.Columns[i].ColumnName.Trim());
if (i == 0)
{
//添加表格
builder.InsertCell();
builder.Write("维修信息:");
//对其方式
builder.CellFormat.HorizontalMerge = CellMerge.Previous;
}
else
{
builder.InsertCell();
builder.Write("");
builder.CellFormat.HorizontalMerge = CellMerge.None;
}
}
builder.EndRow();
//表格对其方式
table.AutoFit(Aspose.Words.Tables.AutoFitBehavior.AutoFitToWindow);
#region##循环表头
foreach (string HeadName in listcolumn)
{
builder.InsertCell();
builder.Write(HeadName);
}
builder.EndRow();
#endregion
#region##循环数据
foreach (DataRow ro in products.Rows)
{
foreach (string HeadName in listcolumn)
{
builder.InsertCell();
builder.Write(ro[HeadName].ToString());
}
builder.EndRow();
}
#endregion
builder.EndTable();