Create a table from data

The following example shows you how to build a formatted Word table from a data collection - a very common reporting task when exporting database results, a grid or a list of objects. The first row is a styled header (bold text with a shaded background) and the remaining rows are filled from the data.

C# example

using System;
using Independentsoft.Office;
using Independentsoft.Office.Word;
using Independentsoft.Office.Word.Tables;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            WordDocument doc = new WordDocument();

            // Sample data (e.g. loaded from a database or collection)
            string[] headers = { "Product", "Quantity", "Price" };
            string[][] rows =
            {
                new string[] { "Keyboard", "3", "$25.00" },
                new string[] { "Mouse", "5", "$15.00" },
                new string[] { "Monitor", "2", "$199.00" }
            };

            Table table = new Table(StandardBorderStyle.SingleLine);
            table.Width = new Width(TableWidthUnit.Percent, 100);

            // Header row
            Row headerRow = new Row();

            for (int i = 0; i < headers.Length; i++)
            {
                Run headerText = new Run(headers[i]);
                headerText.Bold = ExtendedBoolean.True;

                Paragraph headerParagraph = new Paragraph();
                headerParagraph.Add(headerText);

                Shading shading = new Shading(ShadingPattern.Percent10);
                shading.BackgroundColor = "#D9D9D9";

                Cell headerCell = new Cell();
                headerCell.Shading = shading;
                headerCell.Add(headerParagraph);

                headerRow.Add(headerCell);
            }

            table.Add(headerRow);

            // Data rows
            foreach (string[] record in rows)
            {
                Row row = new Row();

                foreach (string value in record)
                {
                    Run cellText = new Run(value);

                    Paragraph cellParagraph = new Paragraph();
                    cellParagraph.Add(cellText);

                    Cell cell = new Cell();
                    cell.Add(cellParagraph);

                    row.Add(cell);
                }

                table.Add(row);
            }

            doc.Body.Add(table);

            doc.Save("c:\\test\\output.docx", true);

            Console.WriteLine("Table created from data successfully!");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office
Imports Independentsoft.Office.Word
Imports Independentsoft.Office.Word.Tables

Module Module1
    Sub Main(ByVal args() As String)

        Dim doc As WordDocument = New WordDocument()

        ' Sample data (e.g. loaded from a database or collection)
        Dim headers As String() = {"Product", "Quantity", "Price"}
        Dim rows As String()() = New String()() _
        {
            New String() {"Keyboard", "3", "$25.00"},
            New String() {"Mouse", "5", "$15.00"},
            New String() {"Monitor", "2", "$199.00"}
        }

        Dim table As Table = New Table(StandardBorderStyle.SingleLine)
        table.Width = New Width(TableWidthUnit.Percent, 100)

        ' Header row
        Dim headerRow As Row = New Row()

        For i As Integer = 0 To headers.Length - 1

            Dim headerText As Run = New Run(headers(i))
            headerText.Bold = ExtendedBoolean.[True]

            Dim headerParagraph As Paragraph = New Paragraph()
            headerParagraph.Add(headerText)

            Dim shading As Shading = New Shading(ShadingPattern.Percent10)
            shading.BackgroundColor = "#D9D9D9"

            Dim headerCell As Cell = New Cell()
            headerCell.Shading = shading
            headerCell.Add(headerParagraph)

            headerRow.Add(headerCell)
        Next

        table.Add(headerRow)

        ' Data rows
        For Each record As String() In rows

            Dim row As Row = New Row()

            For Each value As String In record

                Dim cellText As Run = New Run(value)

                Dim cellParagraph As Paragraph = New Paragraph()
                cellParagraph.Add(cellText)

                Dim cell As Cell = New Cell()
                cell.Add(cellParagraph)

                row.Add(cell)
            Next

            table.Add(row)
        Next

        doc.Body.Add(table)

        doc.Save("c:\test\output.docx", True)

        Console.WriteLine("Table created from data successfully!")

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Word .NET > Tutorial > Create a table from data

Need help? Ask our developers: