Word动态创建表格

起因

最近因为同事发现已经交付的项目,在Word转Pdf后图片不清晰,因为涉及到签名之类,所以只能写Demo去做测试.项目中是使用Office自带的Microsoft.Office.Interop,后期也就一个模块采用Aspose.Words来实现操作Word.采用Office自带的COM组件,每次创建Word/Excel进程,通过RPC进程间通信.在确切问题后,便想起用Aspose.Words该怎么实现动态表格,并填充内容.

表格是根据图片数来动态创建表格的行数和列数.分3*3 3*4 4*4 4*5,表格有又分图片和内容,图片和内容是对应的.行数要乘以2,列数不变.

代码实现

static void Main(string[] args)
{
    List<string> imageList = new List<string>();

    for (int i = 0; i < 9; i++)
    {
        imageList.Add($"{i + 1}.bmp");
    }

    int rows = 0, cols = 0;
    double width = 0f, height = 0f;
    int imgCount = imageList.Count;
    if (imgCount <= 9)
    {
        rows = 6;
        cols = 3;
        width = 160f;
        height = 140f;
    }
    else
    {
        if (imgCount <= 12)
        {
            rows = 6;
            cols = 4;
            width = 106.7f;
            height = 115f;
        }
        else if (imgCount <= 16)
        {
            rows = 8;
            cols = 4;
            width = 92.5f;
            height = 92.5f;

        }
        else
        {
            rows = 8;
            cols = 5;
            width = 83.5f;
            height = 84f;
        }
    }


    //1. 读取word文档
    Document doc = new Document("test.doc");

    //2. 根据书签,定位在哪里创建表格
    DocumentBuilder builder = new DocumentBuilder(doc);
    builder.MoveToBookmark("newLine");

    //3. 创建table
    builder.StartTable();                                  
    builder.CellFormat.Width = 480;
    builder.CellFormat.Borders.LineStyle = LineStyle.None;  //去除边框

    int index = 0;
    int contentIndex = 0;

    for (int i = 0; i < rows; i++)
    {
        if (i % 2 == 0)      
        {
            //奇数行,插入图片
            for (int j = 0; j < cols; j++)
            {
                builder.InsertCell();                       //创建单元格
                builder.InsertImage(imageList[index], width, height);
                index++;
            }
        }
        else
        {
            //偶数行,插入内容
            for (int j = 0; j < cols; j++)
            {
                builder.InsertCell();
                builder.Write(Path.GetFileNameWithoutExtension(imageList[contentIndex]));
                contentIndex++;
            }
        }
        builder.EndRow();                       //行结束
    }


    builder.EndTable();                         //结束table

    doc.Save($"{Guid.NewGuid().ToString()}.docx", SaveFormat.Docx);

    Console.ReadKey();
}

改进

因为对Aspose.Words使用少,在查过API之后,发现有MoveToCell,对上面代码稍作调整.
//根据行数和列数,创建表格所有的单元格
for (int i = 0; i < rows; i++)
{
    for (int j = 0; j < cols; j++)
    {
        builder.InsertCell();
    }
    builder.EndRow();
}

//填充单元格内容
for (int i = 0; i < rows / 2; i++)
{
    for (int j = 0; j < cols; j++)
    {
        int rowNum = i * 2;
        builder.MoveToCell(0, rowNum, j, 0);
        builder.InsertImage(imageList[index++], width, height);

        builder.MoveToCell(0, rowNum + 1, j, 0);
        builder.Write(Path.GetFileNameWithoutExtension(imageList[contentIndex++]));
    }
}
秋风 2019-05-12
文章分类
algorithm windows linux c cpp csharp javascript java dependon mono javascript browser asp.net core go asp.net database python asm rust english TypeScript EntityFramework Core
友情链接