欢迎来到入门教程网!

C#教程

当前位置:主页 > 软件编程 > C#教程 >

OpenXml合并Table单元格代码实例

来源:本站原创|时间:2020-01-10|栏目:C#教程|点击:

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Wordprocessing;
using OpenXML.Model;
using System;
using System.Collections.Generic;

namespace OpenXML
{
  class Program
  {
    //表格数据
    public static List<List<string>> _tabData;

    public Program(List<List<string>> tabData) {
      _tabData = tabData;
    }

    static void Main(string[] args)
    {
      List<string> dataTitle = new List<string>() { "序号","姓名","性别"};
      List<string> data1 = new List<string>() { "1", "张三", "男" };
      List<string> data2 = new List<string>() { "2", "王五", "男" };
      List<string> data3 = new List<string>() { "3", "李四", "女" };

      _tabData = new List<List<string>>();
      _tabData.Add(dataTitle);
      _tabData.Add(data1);
      _tabData.Add(data2);
      _tabData.Add(data3);
      CreateTable(_tabData, @"C:\Users\dzw159\Desktop\WT\VS\OpenXMLFile\openXMLTest.docx",300);

      //CreateOpenXMLFile(@"C:\Users\dzw159\Desktop\WT\VS\OpenXMLFile\openXMLTest.docx");
      Console.WriteLine("Hello World!");
      Console.Read();
    }

    /// <summary>
    /// 创建Word
    /// </summary>
    /// <param name="filePath"></param>
    public static void CreateOpenXMLFile(string filePath)
    {
      using (WordprocessingDocument objWordDocument = WordprocessingDocument.Create(filePath, WordprocessingDocumentType.Document))
      {
        MainDocumentPart objMainDocumentPart = objWordDocument.AddMainDocumentPart();
        objMainDocumentPart.Document = new Document(new Body());
        Body objBody = objMainDocumentPart.Document.Body;
        //创建一些需要用到的样式,如标题3,标题4,在OpenXml里面,这些样式都要自己来创建的  
        //ReportExport.CreateParagraphStyle(objWordDocument); 
        SectionProperties sectionProperties = new SectionProperties();
        PageSize pageSize = new PageSize();
        PageMargin pageMargin = new PageMargin();
        Columns columns = new Columns() { Space = "220" };//720 
        DocGrid docGrid = new DocGrid() { LinePitch = 100 };//360 
                                  //创建页面的大小,页距,页面方向一些基本的设置,如A4,B4,Letter,  
                                  //GetPageSetting(PageSize,PageMargin); 

        //在这里填充各个Paragraph,与Table,页面上第一级元素就是段落,表格. 
        objBody.Append(new Paragraph());
        objBody.Append(new Table());
        objBody.Append(new Paragraph());

        //我会告诉你这里的顺序很重要吗?下面才是把上面那些设置放到Word里去.(大家可以试试把这下面的代码放上面,会不会出现打开openxml文件有误,因为内容有误) 
        sectionProperties.Append(pageSize, pageMargin, columns, docGrid);
        objBody.Append(sectionProperties);

        //如果有页眉,在这里添加页眉. 
        //if (IsAddHead)
        //{
          //添加页面,如果有图片,这个图片和上面添加在objBody方式有点不一样,这里搞了好久. 
          //ReportExport.AddHeader(objMainDocumentPart, image); 
        //}
        objMainDocumentPart.Document.Save();
      }
    }

    /// <summary>
    /// 创建Tab
    /// </summary>
    /// <param name="tabData"></param>
    /// <param name="filePath"></param>
    /// <param name="width"></param>
    public static void CreateTable(List<List<string>> tabData, string filePath,int width)
    {
      //打开Word文件
      using (WordprocessingDocument d = WordprocessingDocument.Open(filePath,true))
      {
        //声明表格
        Table tab = new Table();
        //表格样式
        TableProperties tblProp = new TableProperties(new TableBorders(
          new TableBorders(
            new TopBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single),Size = 4},
             new BottomBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 },
            new LeftBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 },
            new RightBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 },
            new InsideHorizontalBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 },
            new InsideVerticalBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 }
          )
        ));

        //设置表格宽度
        tblProp.TableWidth = new TableWidth() { Width = width.ToString(), Type = TableWidthUnitValues.Dxa };
        //样式添加
        tab.Append(tblProp);

        int j = 0;
        //循环生成单元格
        foreach (var item in tabData)
        {
          //声明Tab行
          TableRow row = new TableRow();
          for (var i = 0; i < item.Count; i++)
          {
            //申明单元格
            TableCell cell = new TableCell();

            TableCellProperties tableCellProperties = new TableCellProperties();
            //单元格样式设置
            TableCellMargin margin = new TableCellMargin();
            margin.LeftMargin = new LeftMargin() {
              Width="100",
              Type = TableWidthUnitValues.Dxa
            };
            margin.RightMargin = new RightMargin()
            {
              Width = "100",
              Type = TableWidthUnitValues.Dxa
            };
            tableCellProperties.Append(margin);

            Paragraph par = new Paragraph();
            Run run = new Run();


            //如果同一列的参数相同(合并单元格)
            if (j < (tabData.Count - 1) && item[i] == tabData[j + 1][i])
            {
              VerticalMerge verticalMerge = new VerticalMerge() {
                Val = MergedCellValues.Restart
              };
              //RunProperties rpr = new RunProperties();
              //rpr.Append(new Bold());
              //run.Append(rpr);
              //verticalMerge.Val = MergedCellValues.Restart;
              //Text t = new Text(item[i]);
              //t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve);

              //run.Append(t);

              TableCellProperties tableCellProperties2 = new TableCellProperties();
              tableCellProperties2.Append(verticalMerge);
              cell.Append(tableCellProperties2);
              Text t = new Text(item[i]);
              t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve);
              run.Append(t);
            }
            //和上一行比较(合并单元格)
            else if (j>0 && j < (tabData.Count) && item[i] == tabData[j -1][i])
            {

              VerticalMerge verticalMerge = new VerticalMerge()
              {
                Val = MergedCellValues.Continue
              };
              TableCellProperties tableCellProperties2 = new TableCellProperties();
              tableCellProperties2.Append(verticalMerge);
              cell.Append(tableCellProperties2);
              Text t = new Text(item[i]);
              t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve);
              run.Append(t);
            }
            else
            {
              //RunProperties rPr = new RunProperties();
              //rPr.Append(new Bold());
              //run.Append(rPr);

              //单元格内容添加(由内向外顺序)
              Text t = new Text(item[i]);
              t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve);
              run.Append(t);
            }
            par.Append(run);
            cell.Append(tableCellProperties);
            cell.Append(par);
            row.Append(cell);

          }
          j++;
          //表格添加行
          tab.Append(row);
        }
        //objBody.Append(new Paragraph());
        //objBody.Append(new Table());
        

        d.MainDocumentPart.Document.Body.Append(new Paragraph(new Run(tab)));
        d.MainDocumentPart.Document.Save();
      }

    }
    

  }
}

注:他们有的说,标记为MergedCellValues.Continue的纵向单元格一定要给值!(这个我试着给赋值null或者为“”,都能正常合并)

以上就是全部知识点内容,感谢大家的阅读和对我们的支持。

上一篇:c#中将uint值转换成int的实例方法

栏    目:C#教程

下一篇:C#项目中跨文件调用公共类的实例方法

本文标题:OpenXml合并Table单元格代码实例

本文地址:https://www.xiuzhanwang.com/a1/C_jiaocheng/4690.html

网页制作CMS教程网络编程软件编程脚本语言数据库服务器

如果侵犯了您的权利,请与我们联系,我们将在24小时内进行处理、任何非本站因素导致的法律后果,本站均不负任何责任。

联系QQ:835971066 | 邮箱:835971066#qq.com(#换成@)

Copyright © 2002-2020 脚本教程网 版权所有