Demos > Booking Sheet with Text Box


This demo shows the power of text box and paragraph support in Simple API.

The background of this demo is that a travel agency has to help customers book hotel. They have a spreadsheet file in hand, which records all of the visitors' information. They need to generate an order form with the requirements of hotel reservation using these data. A order form template has been supplied. This program generates order forms for all the visitors based on records of passengers in spreadsheet and the given template.

Code Introduction

There code of this demo is very simple. First, load template document and spreadsheet separately. Secondly, iterate data table and create new section and paragraph. The Text Boxes in the paragraph are also cloned. All of them are iterated and filled information from data table.
Data items counts are also computed. These counts are wrote to the bottom table of the sheet.

public static void main(String[] args) {
    try {
        // load template document
        TextDocument doc = TextDocument.loadDocument("DemoTemplate.odt");
        Table roomtable = doc.getTableByName("RoomTable");
        Section templateSection = doc.getSectionByName("SectionForm");
        // load passenger data document
        SpreadsheetDocument data = SpreadsheetDocument.loadDocument("Passengers.ods");
        Table table = data.getTableByName("passenger");
        int count = table.getRowCount();
        int type1Count = 0, type2Count = 0, type3Count = 0;
        for (int i = 1; i < count; i++) {
            Row row = table.getRowByIndex(i);
            for (int j = 0; j < 6; j++) {
                Paragraph para = templateSection.getParagraphByIndex(j, false);
                Textbox nameBox = para.getTextboxIterator().next();
                String content = row.getCellByIndex(j).getDisplayText();
                if (j == 5) {
                    if (content.equals("Deluxe Room"))
                    else if (content.equals("Studio/Junior Suite"))
                    else if (content.equals("Executive Suite"))
            doc.appendSection(templateSection, false);
        roomtable.getCellByPosition(2, 1).setStringValue(type1Count + "");
        roomtable.getCellByPosition(2, 2).setStringValue(type2Count + "");
        roomtable.getCellByPosition(2, 3).setStringValue(type3Count + "");

    } catch (Exception e) {



Powered by the Simple Java API for ODF version 0.5.
You can download the code of this demo from here.

Powered by the Apache CMS.

Apache "ODF Toolkit" is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright © 2011 The Apache Software Foundation Licensed under the Apache License, Version 2.0. Contact Us
Apache and the Apache feather logos are trademarks of The Apache Software Foundation.
Other names appearing on the site may be trademarks of their respective owners.