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.Ge荏鱿胫协neric;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文档，前后效果对比图如下：