Word formatting issue

Aspose.Words Product Family
1

I need populate the data from dataset into a word table. I am facing some issues while formatting the output. I am using MailMerge to populate the data from data-table to word table. Below is the sample data.

Data-Table:

Location Name Age
India A 2
India B 4
India C 5
India D 6
India E 7
US F 9
US G 8
US H 10
US I 11

Intended format in word table:

Name Age
India
A 2
B 4
C 5
D 6
E 7
US
F 9
G 8
H 10
I 11

Please help me with the code to get above formatting details.

Regards,
Aniket

2

Hi Aniket,

Thanks for your inquiry. Sure, you can achieve this by using Nested Mail Merge Regions functionality of Aspose.Words. I have attached sample input/output documents here for your reference. Here is the sample code:

// inside main
DataTable table = GetDataTable();
DataView view = new DataView(table);
DataTable parent = view.ToTable("Parent", true, new string[]
{
    "Location"
});
DataTable child = view.ToTable("Child", true, new string[]
{
    "Location",
    "Name",
    "Age"
});
DataSet ds = new DataSet();
ds.Tables.Add(parent);
ds.Tables.Add(child);
ds.Relations.Add(new DataRelation("rel", parent.Columns[0], child.Columns[0], true));
Document doc = new Document(@"C:\Temp\in.docx");
doc.MailMerge.ExecuteWithRegions(ds);
doc.Save(@"C:\Temp\out.docx");

// helper method
private static DataTable GetDataTable()
{
    DataTable dataTable = new DataTable("table");
    dataTable.Columns.Add(new DataColumn("Location", typeof(string)));
    dataTable.Columns.Add(new DataColumn("Name", typeof(string)));
    dataTable.Columns.Add(new DataColumn("Age", typeof(string)));
    DataRow dataRow = dataTable.NewRow();
    dataRow["Location"] = "India";
    dataRow["Name"] = "A";
    dataRow["Age"] = "2";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "India";
    dataRow["Name"] = "B";
    dataRow["Age"] = "4";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "India";
    dataRow["Name"] = "C";
    dataRow["Age"] = "5";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "India";
    dataRow["Name"] = "D";
    dataRow["Age"] = "6";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "India";
    dataRow["Name"] = "E";
    dataRow["Age"] = "7";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "US";
    dataRow["Name"] = "F";
    dataRow["Age"] = "9";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "US";
    dataRow["Name"] = "G";
    dataRow["Age"] = "8";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "US";
    dataRow["Name"] = "H";
    dataRow["Age"] = "10";
    dataTable.Rows.Add(dataRow);
    dataRow = dataTable.NewRow();
    dataRow["Location"] = "US";
    dataRow["Name"] = "I";
    dataRow["Age"] = "11";
    dataTable.Rows.Add(dataRow);
    return dataTable;
}

I hope, this helps.

Best regards,