Podrška #15859: odftookit - java dom - java - bring.out redmine

Akcije

Copy link

Podrška #15859

Zatvoren

odftookit - java dom

Dodano od Ernad Husremović prije više od 17 godina. Izmjenjeno prije više od 17 godina.

Status:

Zatvoreno

Prioritet:

Normalan

Odgovorna osoba:

Ernad Husremović

Početak:

18.11.2008

Završetak:

% završeno:

100%

Procjena vremena:

Opis

kreiranje open document format dokumenata bez openoffice-a

http://odftoolkit.org/

The ODF Toolkit provides a home for libraries that ease the development of applications that support ODF , the unique vendor neutral open standard for office documents. The ODF Toolkit further provides a home for tools that process ODF or check ODF conformance.

The range of projects that are available in the ODF Toolkit goes from small tools that simplify using ODF in the software development process, over an ODF validation tool up to large ODF Java and .NET libraries that can be used within other projects. And this is just the start. Developers are invited to freely host their open source ODF libraries and tools within the ODF Toolkit, to join the existing projects, and to collaborate with ODF developers everywhere.

The ODF Toolkit provides Mercurial for hosting your code, forums, mailing lists, wikis, an issue tracking system, and personalized home pages. More will come.

Fajlovi

Download all files

odftoolkit_1.png (36,3 KB) odftoolkit_1.png		Ernad Husremović, 18.11.2008 07:58
odftoolkit_1.ods (4,83 KB) odftoolkit_1.ods		Ernad Husremović, 18.11.2008 07:58

Akcije

Copy link Download all files

Izmjenjeno od Ernad Husremović prije više od 17 godina

Fajl odftoolkit_1.png odftoolkit_1.png dodano
Fajl odftoolkit_1.ods odftoolkit_1.ods dodano

package ba.out.bring;

import java.io.File;
import org.openoffice.odf.dom.OdfNamespace;
import org.openoffice.odf.doc.OdfDocument;
import org.openoffice.odf.doc.OdfFileDom;
import org.openoffice.odf.doc.OdfSpreadsheetDocument;
import org.openoffice.odf.doc.element.style.OdfStyle;
import org.openoffice.odf.doc.element.table.OdfTable;
import org.openoffice.odf.doc.element.table.OdfTableCell;
import org.openoffice.odf.doc.element.table.OdfTableColumn;
import org.openoffice.odf.doc.element.table.OdfTableRow;
import org.openoffice.odf.doc.element.text.OdfParagraph;

import org.openoffice.odf.doc.element.text.OdfTableFormula;

import org.openoffice.odf.doc.element.table.OdfTableColumn;
import org.openoffice.odf.doc.element.number.OdfNumber;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

public class MainClass {

    private static final String TEST_FILE_SAVE_2TABLES_OUT = "/home/hernad/Desktop/odftoolkit_1.ods";

    public MainClass() {
    }

    public static void main(String[] args) {

        try {
        OdfSpreadsheetDocument mysheet;

        mysheet = OdfSpreadsheetDocument.createSpreadsheetDocument();

        OdfFileDom odt = mysheet.getContentDom();

        // find the first table in the sheet
        NodeList lst =
                odt.getElementsByTagNameNS(OdfTable.ELEMENT_NAME.getUri(), OdfTable.ELEMENT_NAME.getLocalName());
        OdfTable mytable = (OdfTable) lst.item(0);
        mytable.setName("Cars Sheet");

        // remove first empty row of table.
        mytable.removeChild(mytable.getFirstChild().getNextSibling());

        OdfTableRow  row;
        OdfTableCell cell;
        OdfParagraph p;
        OdfTableColumn column;
        OdfNumber number;

        for (int i = 0; i < 10; i++) {
                    number = (OdfNumber) new OdfNumber(mysheet.getContentDom());
                    number.setDecimalPlaces(2);

                    row = (OdfTableRow) mytable.appendChild(new OdfTableRow(odt));
                    //column = (OdfTableColumn) mytable.appendChild(new OdfTableColumn(odt));
                    cell = (OdfTableCell) row.appendChild(new OdfTableCell(odt));
                    cell.setAttribute("office:value-type", "float");
                    cell.setAttribute("office:value", "1");

                    //cell = (OdfTableCell) column.appendChild(new OdfTableCell(odt));
                    p = new OdfParagraph(odt);
                    p.appendChild(odt.createTextNode("1"));
                    cell.appendChild(p);

            }

            //OdfTableFormula formula = new OdfTableFormula(odt);

            //formula.setFormula("SUM([.A1:.A5])");

            row = (OdfTableRow) mytable.appendChild(new OdfTableRow(odt));
                    //column = (OdfTableColumn) mytable.appendChild(new OdfTableColumn(odt));
            cell = (OdfTableCell) row.appendChild(new OdfTableCell(odt));

            cell.setFormula("=SUM(A1:A10)*2 + 15");

            cell.setAttribute("office:value-type", "float");
            cell.setAttribute("office:value", "1");

            p = new OdfParagraph(odt);
            p.appendChild(odt.createTextNode("1"));
            cell.appendChild(p);

        // 2nd Table
        OdfTable my2table = new OdfTable(odt);

        Element spreadsheetElement = (Element) odt.getElementsByTagNameNS(OdfNamespace.OFFICE.getUri(), "spreadsheet").item(0);
        my2table.setAttributeNS(OdfNamespace.TABLE.getUri(), "name", "BikesSheet");

        spreadsheetElement.appendChild(my2table);

        OdfTableRow row2 = (OdfTableRow) my2table.appendChild(new OdfTableRow(odt));
        OdfTableCell cell2 = (OdfTableCell) row2.appendChild(new OdfTableCell(odt));

        OdfParagraph p2 = new OdfParagraph(odt);
        p2.appendChild(odt.createTextNode("Bandit 600"));
        cell2.appendChild(p2);

        mysheet.save(TEST_FILE_SAVE_2TABLES_OUT);

        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}