Working with Tables

Extracting Plain Text from the Table of OneNote Document

Aspose.Note for JAVA 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.

This article shows how to:

• Get table text from a OneNote document.
• Get row text from a table in a OneNote document.
• Get cell text from a row in a table.

Get Table Text from OneNote Document

This example works as follows:

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

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

String dataDir = Utils.getSharedDataDir(ExtractTextFromTable.class) + "tables/";

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

// Get a list of table nodes
List<Table> nodes = document.getChildNodes(Table.class);

for (int i = 0; i < nodes.size(); i++) {
	Table table = nodes.get(i);
	System.out.println("Table # " + i);

	// Retrieve text
	List<RichText> textNodes = (List<RichText>) table.getChildNodes(RichText.class);
	StringBuilder text = new StringBuilder();
	for (RichText richText : textNodes) {
		text = text.append(richText.getText().toString());
	}
	
	// Print text on the output screen
	System.out.println(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 stream-based code to extract text.
5. Display the text on the output screen.

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

String dataDir = Utils.getSharedDataDir(ExtractRowtextfromtableinOneNotedocument.class) + "tables/";

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

// Get a list of table nodes
List<Table> nodes = (List<Table>) document.getChildNodes(Table.class);

// Set row count
int rowCount = 0;

for (Table table : nodes) {
	// Iterate through table rows
	for (TableRow row : table) {
		rowCount++;
		// Retrieve text
		List<RichText> textNodes = (List<RichText>) row.getChildNodes(RichText.class);
		StringBuilder text = new StringBuilder();
		for (RichText richText : textNodes) {
			text = text.append(richText.getText().toString());
		}
		
		// Print text on the output screen
		System.out.println(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 stream-based code to extract text.
7. Display the text on the output screen.

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

String dataDir = Utils.getSharedDataDir(GetCellTextFromRowOfTable.class) + "tables/";

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

// Get a list of table nodes
List<Table> nodes = (List<Table>) document.getChildNodes(Table.class);


for (Table table : nodes) {
	// Iterate through table rows
	for (TableRow row : table) {
		// Get list of TableCell nodes
		List<TableCell> cellNodes = (List<TableCell>) row.getChildNodes(TableCell.class);
		// iterate through table cells
		for (TableCell cell : cellNodes) {
			// Retrieve text
			List<RichText> textNodes = (List<RichText>) cell.getChildNodes(RichText.class);
			StringBuilder text = new StringBuilder();
			for (RichText richText : textNodes) {
				text = text.append(richText.getText().toString());
			}
			
			// Print text on the output screen
			System.out.println(text);
		}
	}
}

Insert a Table in OneNote Document

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

Aspose.Note for Java offers the Document class that represents a OneNote file. Developers can append content under the 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 example shows how to insert a table in a OneNote document.

// The path to th documents directory.
String dataDir = Utils.getSharedDataDir(InsertTable.class) + "tables\\";

Document doc = new Document();

// Initialize Page class object
Page page = new 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);
table.setBordersVisible(true);
TableColumn col = new TableColumn();
col.setWidth(200);

table.getColumns().addItem(col);
table.getColumns().addItem(col);
table.getColumns().addItem(col);

// 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 Java APIs allows developers to insert a table at a 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 Java offers the Document class that represents a OneNote file. Developers can append content under the TableCell node, table cells to the TableRow node, table row to the Table node. LockedWidth property of the Table class allows bolting 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 example shows how to insert a table with locked columns in a OneNote document.

        String dataDir = Utils.getSharedDataDir(CreateTableWithLockedColumns.class) + "tables\\";

        // Create an object of the Document class
        Document doc = new Document();

        // Initialize Page class object
        Page page = new 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);
        table.setBordersVisible(true);

        TableColumn col = new TableColumn();
        col.setWidth(200);
        col.setLockedWidth(true);

        table.getColumns().addItem(col);

        // 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();
    textStyle.setFontColor(Color.BLACK);
    textStyle.setFontName("Arial");
    textStyle.setFontSize(10);;

    RichText richText = new RichText(doc);
    richText.setText(text);
    richText.setParagraphStyle(textStyle);

    outlineElem.appendChildLast(richText);
    return outlineElem;
}

Setting Cell Background Color

// Load the document into Aspose.Note.
Document doc = new Document();

// Initialize TableRow class object
TableRow row1 = new TableRow(doc);
// Initialize TableCell class object and set text content
TableCell cell11 = new TableCell(doc);
cell11.appendChildLast(GetOutlineElementWithText(doc, "Small text"));
cell11.setBackgroundColor(Color.BLACK);
row1.appendChildLast(cell11);

Changing style of a table

    private static void setRowStyle(TableRow row, Color highlightColor, boolean bold, boolean italic) {
        for (TableCell cell: row)
        {
            cell.setBackgroundColor(highlightColor);

            for (RichText node: cell.getChildNodes(RichText.class))
            {
                node.getParagraphStyle().setBold(bold);
                node.getParagraphStyle().setItalic(italic);

                for (TextStyle style: node.getStyles())
                {
                    style.setBold(bold);
                    style.setItalic(italic);
                }
            }
        }
    }

    public static void main(String... args) throws IOException {
        String dataDir = Utils.getSharedDataDir(CreateTableWithLockedColumns.class) + "tables\\";

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

        // Get a list of table nodes
        List<Table> nodes = document.getChildNodes(Table.class);

        for (Table table: nodes)
        {
            setRowStyle(table.getFirstChild(), Color.GRAY, true, true);

            // Highlight first row after head.
            boolean flag = false;
            List<TableRow> rows = table.getChildren();
            for (int i = 1; i < rows.size(); ++i)
            {
                setRowStyle(rows.get(i), flag ? Color.lightGray : new java.awt.Color(-1, true), false, false);

                flag = !flag;
            }
        }

        document.save(Paths.get(dataDir, "ChangeTableStyleOut.one").toString());
    }