Work, Extract, Insert Tables in OneNote Document using C#

Extracting Plain Text from the Table of OneNote Document

Aspose.Note for .NET allows developers to extract text from the entire table, a row or a particular cell element.

Aspose.Note for .NET offers the Document class that represents a OneNote file. The Document class exposes the GetChildNodes method that can be called to extract table nodes from a OneNote document.

Get Table Text from OneNote Document

This example works as follows:

1. Create an object of the Document class.
2. Call the Document class’ GetChildNodes method.
3. Retrieve a list of table nodes.
4. Call the LINQ-based Code to extract text
5. Display text on the output screen.

The following code example demonstrates how to get table text from a OneNote document.

// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Tables();

// Load the document into Aspose.Note.
Document document = new Document(dataDir + "Sample1.one");

// Get a list of table nodes
IList<Table> nodes = document.GetChildNodes<Table>();

// Set table count
int tblCount = 0;

foreach (Table table in nodes)
{
    tblCount++;
    Console.WriteLine("table # " + tblCount);

    // Retrieve text
    string text = string.Join(Environment.NewLine, table.GetChildNodes<RichText>().Select(e => e.Text)) + Environment.NewLine;
    // Print text on the output screen
    Console.WriteLine(text);
}

Get Row Text from a Table in a OneNote Document

This example works as follows:

1. Create an object of the Document class.
2. Filter out a list of table nodes.
3. Iterate through table rows.
4. Call the LINQ-based Code to extract text.
5. Display the text on the output screen.

The following code example demonstrates how to extract row text from a table in a OneNote document.

// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Tables();

// Load the document into Aspose.Note.
Document document = new Document(dataDir + "Sample1.one");

// Get a list of table nodes
IList<Table> nodes = document.GetChildNodes<Table>();

// Set row count
int rowCount = 0;

foreach (Table table in nodes)
{
    // Iterate through table rows
    foreach (TableRow row in table)
    {
        rowCount++;
        // Retrieve text
        string text = string.Join(Environment.NewLine, row.GetChildNodes<RichText>().Select(e => e.Text)) + Environment.NewLine;
        // Print text on the output screen
        Console.WriteLine(text);
    }
}

Get Cell Text from a Row in a Table

This example works as follows:

1. Create an object of the Document class.
2. Filter out a list of table nodes.
3. Iterate through the table rows.
4. Filter out a list of cell nodes from each row.
5. Iterate through the row cells.
6. Call the LINQ-based Code to extract text.
7. Display the text on the output screen.

The following code example demonstrates how to get cell text from a row of the table.

// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Tables();

// Load the document into Aspose.Note.
Document document = new Document(dataDir + "Sample1.one");

// Get a list of table nodes
IList<Table> nodes = document.GetChildNodes<Table>();        

foreach (Table table in nodes)
{
    // Iterate through table rows
    foreach (TableRow row in table)
    {
        // Get list of TableCell nodes
        IList<TableCell> cellNodes = row.GetChildNodes<TableCell>();
        // Iterate through table cells
        foreach (TableCell cell in cellNodes)
        {
            // Retrieve text
            string text = string.Join(Environment.NewLine, cell.GetChildNodes<RichText>().Select(e => e.Text)) + Environment.NewLine;
            // Print text on the output screen
            Console.WriteLine(text);
        }
    }
}

Insert a Table in OneNote Document

Aspose.Note for .NET APIs allows developers to insert a table at the particular node position. This article is meant to show you how to create a table in OneNote document programmatically.

Aspose.Note for .NET offers the Document class that represents a OneNote file. Developers can append content under TableCell node, table cells to the TableRow node, table row to the Table node. Later they could append table under OutlineElement node, outline element to Outline node, outline to Page node and then a page to the Document node. It’s all based on the Aspose.Note DOM structure.

The following code example demonstrates how to insert a table in a OneNote document.

// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Tables();

// Create an object of the Document class
Document doc = new Document();
// Initialize Page class object
Aspose.Note.Page page = new Aspose.Note.Page(doc);

// Initialize TableRow class object
TableRow row1 = new TableRow(doc);
// Initialize TableCell class objects
TableCell cell11 = new TableCell(doc);
TableCell cell12 = new TableCell(doc);
TableCell cell13 = new TableCell(doc);

// Append outline elements in the table cell
cell11.AppendChildLast(GetOutlineElementWithText(doc, "cell_1.1"));
cell12.AppendChildLast(GetOutlineElementWithText(doc, "cell_1.2"));
cell13.AppendChildLast(GetOutlineElementWithText(doc, "cell_1.3"));
// Table cells to rows
row1.AppendChildLast(cell11);
row1.AppendChildLast(cell12);
row1.AppendChildLast(cell13);

// Initialize TableRow class object
TableRow row2 = new TableRow(doc);
// initialize TableCell class objects
TableCell cell21 = new TableCell(doc);
TableCell cell22 = new TableCell(doc);
TableCell cell23 = new TableCell(doc);

// Append outline elements in the table cell
cell21.AppendChildLast(GetOutlineElementWithText(doc, "cell_2.1"));
cell22.AppendChildLast(GetOutlineElementWithText(doc, "cell_2.2"));
cell23.AppendChildLast(GetOutlineElementWithText(doc, "cell_2.3"));

// Append table cells to rows
row2.AppendChildLast(cell21);
row2.AppendChildLast(cell22);
row2.AppendChildLast(cell23);

// Initialize Table class object and set column widths
Table table = new Table(doc)
{
    IsBordersVisible = true,
    Columns = { new TableColumn { Width = 200 }, new TableColumn { Width = 200 }, new TableColumn { Width = 200 } }
};
// Append table rows to table
table.AppendChildLast(row1);
table.AppendChildLast(row2);

// Initialize Outline object
Outline outline = new Outline(doc);
// Initialize OutlineElement object
OutlineElement outlineElem = new OutlineElement(doc);
// Add table to outline element node
outlineElem.AppendChildLast(table);
// Add outline element to outline
outline.AppendChildLast(outlineElem);
// Add outline to page node
page.AppendChildLast(outline);
// Add page to document node
doc.AppendChildLast(page);
dataDir = dataDir + "InsertTable_out.one";
doc.Save(dataDir);

Create a Table with Locked Columns in the OneNote Document

Aspose.Note for .NET APIs allows developers to insert a table at the particular node position. This article is meant to show you how to create a table with a locked column in OneNote document programmatically.

Aspose.Note for .NET offers the Document class that represents a OneNote file. Developers can append content under TableCell node, table cells to the TableRow node, table row to the Table node. LockedWidth property of the Table class allows to bolt its width. Later they could append table under OutlineElement node, outline element to Outline node, outline to Page node and then a page to the Document node. It’s all based on the Aspose.Note DOM structure.

The following code example demonstrates how to insert a table with locked columns in a OneNote document.

// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Tables();

// Create an object of the Document class
Document doc = new Document();
// Initialize Page class object
Aspose.Note.Page page = new Aspose.Note.Page(doc);

// Initialize TableRow class object
TableRow row1 = new TableRow(doc);
// Initialize TableCell class object and set text content
TableCell cell11 = new TableCell(doc);
cell11.AppendChildLast(InsertTable.GetOutlineElementWithText(doc, "Small text"));
row1.AppendChildLast(cell11);

// Initialize TableRow class object
TableRow row2 = new TableRow(doc);
// Initialize TableCell class object and set text content
TableCell cell21 = new TableCell(doc);
cell21.AppendChildLast(InsertTable.GetOutlineElementWithText(doc, "Long   text    with    several   words and    spaces."));
row2.AppendChildLast(cell21);

// Initialize Table class object
Table table = new Table(doc)
{
    IsBordersVisible = true,
    Columns = { new TableColumn { Width = 70, LockedWidth = true } }
};
// Add rows
table.AppendChildLast(row1);
table.AppendChildLast(row2);

Outline outline = new Outline(doc);
OutlineElement outlineElem = new OutlineElement(doc);
// Add table node
outlineElem.AppendChildLast(table);
// Add outline element node
outline.AppendChildLast(outlineElem);
// Add outline node
page.AppendChildLast(outline);
// Add page node
doc.AppendChildLast(page);
dataDir = dataDir + "CreateTableWithLockedColumns_out.one";
doc.Save(dataDir);

GetOutlineElementWithText Method

public static OutlineElement GetOutlineElementWithText(Document doc, string text)
{
    OutlineElement outlineElem = new OutlineElement(doc);
    ParagraphStyle textStyle = new ParagraphStyle { FontColor = Color.Black, FontName = "Arial", FontSize = 10 };
    outlineElem.AppendChildLast(new RichText(doc) { Text = text, ParagraphStyle = textStyle });
    return outlineElem;
}

Setting Cell Background Color

// Create an object of the Document class
Document doc = new Document();
// Initialize Page class object
Aspose.Note.Page page = new Aspose.Note.Page(doc);

// Initialize TableRow class object
TableRow row1 = new TableRow(doc);
// Initialize TableCell class object and set text content
TableCell cell11 = new TableCell(doc);
cell11.AppendChildLast(InsertTable.GetOutlineElementWithText(doc, "Small text"));
cell11.BackgroundColor = Color.Coral;
row1.AppendChildLast(cell11);  

Changing style of a table

        private static void SetRowStyle(TableRow row, Color highlightColor, bool bold, bool italic)
        {
            foreach (var cell in row)
            {
                cell.BackgroundColor = highlightColor;

                foreach (var node in cell.GetChildNodes<RichText>())
                {
                    node.ParagraphStyle.IsBold = bold;
                    node.ParagraphStyle.IsItalic = italic;

                    foreach (var style in node.Styles)
                    {
                        style.IsBold = bold;
                        style.IsItalic = italic;
                    }
                }
            }
        }
        
        [STAThread]
        public static void Main()
        {
            string dataDir = RunExamples.GetDataDir_Tables();

            // Load the document into Aspose.Note.
            Document document = new Document(dataDir + "ChangeTableStyleIn.one");

            // Get a list of table nodes
            IList<Table> nodes = document.GetChildNodes<Table>();

            foreach (Table table in nodes)
            {
                SetRowStyle(table.First(), Color.DarkGray, true, true);

                // Highlight first row after head.
                var flag = false;
                foreach (var row in table.Skip(1))
                {
                    SetRowStyle(row, flag ? Color.LightGray : Color.Empty, false, false);

                    flag = !flag;
                }
            }

            document.Save(Path.Combine(dataDir, "ChangeTableStyleOut.one"));
        }