Calculate SUM & AVERAGE Formula Fields during Mail Merge using C# Example

Aspose.Words Product Family
1

Hi,

Can you please share the SumAvgExample.zip attachment and output.zip attachment?

Thanks.

2

Hi,

Can you please share the SumAvgExample.zip attachment and output.zip attachment?

Thanks.

3

Hi Awais,

Can you please share the SumAvgExample.zip attachment and output.zip attachment?

Thanks.

4

@codelabs Please find the attachment.SumAvgExample.zip (18.7 KB) And the code:

Document doc = new Document("E:\\Temp\\SumAvgExample (1)\\SumAvgExample.docx");
doc.MailMerge.ExecuteWithRegions(GetDataTable());
doc.UpdateFields();
doc.Save("E:\\Temp\\SumAvgExample (1)\\20.5.docx");

private static DataTable GetDataTable()
{
    DataTable dataTable = new DataTable("tbl");

    dataTable.Columns.Add(new DataColumn("mf1"));
    dataTable.Columns.Add(new DataColumn("mf2"));

    DataRow dataRow;
    for (int i = 1; i < 5; i++)
    {
        dataRow = dataTable.NewRow();

        dataRow[0] = i;
        dataRow[1] = i;

        dataTable.Rows.Add(dataRow);
    }

    return dataTable;
}