C# 将 Excel 表格导入 Word
1、下载并安装Spire.Office for .NET, 下载地址：http://www.e-iceblue.cn/Introduce/Spire-Office-NET.html
2、引用Spire.Xls.dll 和 Spire.Doc.dll文件到项目
3、将代码放到Visual Studio中
【C#】
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Xls;
using Spire.Doc.Fields;
using Spire.Doc.Documents;
namespace excel_to_word
{
class Program
{
static void Main(string[] args)
{
//创建Workbook对象
Workbook workbook = new Workbook();
//加载Excel文档
workbook.LoadFromFile(@"Sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//创建Document对象，即Word文档
Document doc = new Document();
//在Word中添加表格
Table table = doc.AddSection().AddTable(true);
//根据Excel表格数据所占的行数和列数设置表格的行和列
table.ResetCells(sheet.LastRow, sheet.LastColumn);
//遍历Excel表格的行
for (int r = 1; r <= sheet.LastRow; r++)
{
//遍历Excel表格的列
for (int c = 1; c <= sheet.LastColumn; c++)
{
//获取Excel表格的单元格
CellRange xCell = sheet.Range[r, c];
//获取Word表格的单元格
TableCell wCell = table.Rows[r - 1].Cells[c - 1];
//将Excel单元格数据填充到对应的Word单元格
TextRange textRange = wCell.AddParagraph().AppendText(xCell.NumberText);
//复制单元格格式
CopyStyle(textRange, xCell, wCell);
}
}
//保存文档
doc.SaveToFile("result.docx", Spire.Doc.FileFormat.Docx);
}
private static void CopyStyle(TextRange wTextRange, CellRange xCell, TableCell wCell)
{
//复制字体样式
wTextRange.CharacterFormat.TextColor = xCell.Style.Font.Color;
wTextRange.CharacterFormat.FontSize = (float)xCell.Style.Font.Size;
wTextRange.CharacterFormat.FontName = xCell.Style.Font.FontName;
wTextRange.CharacterFormat.Bold = xCell.Style.Font.IsBold;
wTextRange.CharacterFormat.Italic = xCell.Style.Font.IsItalic;
//复制单元格背景色
wCell.CellFormat.BackColor = xCell.Style.Color;
//复制文字对齐方式
switch (xCell.HorizontalAlignment)
{
case HorizontalAlignType.Left:
wTextRange.OwnerParagraph.Format.HorizontalAlignment = HorizontalAlignment.Left;
break;
case HorizontalAlignType.Center:
wTextRange.OwnerParagraph.Format.HorizontalAlignment = HorizontalAlignment.Center;
break;
case HorizontalAlignType.Right:
wTextRange.OwnerParagraph.Format.HorizontalAlignment = HorizontalAlignment.Right;
break;
}
}
｝
｝
4、调试并运行代码后，生成word文档，前后效果对比图如下：
