Package org.odftoolkit.odfdom.dom.element.office

Examples of org.odftoolkit.odfdom.dom.element.office.OfficeSpreadsheetElement

163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
      timefile = new FileInputStream(time_spreadsheet);
      timedoc = Document.loadDocument(timefile);
    } catch (FileNotFoundException e) {
      //Create an empty spreadsheet
      timedoc = SpreadsheetDocument.newSpreadsheetDocument();
      OfficeSpreadsheetElement spreadsheet = (OfficeSpreadsheetElement) timedoc.getContentDom().getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);
      spreadsheet.removeChild(spreadsheet.getFirstChild());
    }

    try {
      memoryfile = new FileInputStream(memory_spreadsheet);
      memorydoc = Document.loadDocument(memoryfile);
    } catch (FileNotFoundException e) {
      //Create an empty spreadsheet
      memorydoc = SpreadsheetDocument.newSpreadsheetDocument();
      OfficeSpreadsheetElement spreadsheet = (OfficeSpreadsheetElement) memorydoc.getContentDom().getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);
      spreadsheet.removeChild(spreadsheet.getFirstChild());
    }

    String[] summaryName = new String[]{"Load All Documents", "Parse All Documents", "Save All Documents"};
    updateTableCells(timedoc, "Summary", totalTime, summaryName);
    updateTableCells(timedoc, "Load ODF", totalLoadTimeForEach, TEST_FILE_NAME);
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
    OdfFileDom dom;
    NodeList tableList;
    TableTableElement myTable;
    NodeList lst;
    OdfTextParagraph p;
    OfficeSpreadsheetElement spreadsheet = null;

    try {
      dom = odfdoc.getContentDom();
      tableList = dom.getElementsByTagNameNS(
          OdfDocumentNamespace.TABLE.getUri(), "table");
      spreadsheet = (OfficeSpreadsheetElement) dom.getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);

      i = 0;
      if (tableList.getLength() > 0) {
        for (; i < tableList.getLength(); i++) {
          String currentname = ((TableTableElement) tableList.item(i)).getTableNameAttribute();
          if (currentname == null) {
            currentname = "";
          }
          if (currentname.equalsIgnoreCase(tablename)) {
            break;
          }
        }
      }
      if (i < tableList.getLength()) //table with the specific table name is found
      {
        myTable = (TableTableElement) tableList.item(i);
      } else { //table with the specific table name is not found. Create table
        myTable = dom.newOdfElement(TableTableElement.class);
        myTable.setTableNameAttribute(tablename);
        spreadsheet.appendChild(myTable);
      }

      lst = myTable.getElementsByTagNameNS(OdfDocumentNamespace.TABLE.getUri(), "table-row");
      if (lst.getLength() == 0) { //the first table row is not existed. Create table row
        td = dom.newOdfElement(TableTableRowElement.class);
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
    if (index < 0) {
      return null;
    }
    int count = 0;
    try {
      OfficeSpreadsheetElement spreadsheetElement = getContentRoot();
      Node child = spreadsheetElement.getFirstChild();
      while ((child != null) && (count <= index)) {
        if (child instanceof TableTableElement) {
          if (count == index) {
            return getTableBuilder().getTableInstance((TableTableElement) child);
          } else {
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
357
    if (before < 0) {
      return null;
    }
    int count = 0;
    try {
      OfficeSpreadsheetElement spreadsheetElement = getContentRoot();
      Node child = spreadsheetElement.getFirstChild();
      while ((child != null) && (count <= before)) {
        if (child instanceof TableTableElement) {
          if (count == before) {
            Table table = getTableBuilder().newTable();
            getContentRoot().insertBefore(table.getOdfElement(), child);
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
407
    if (before < 0) {
      return null;
    }
    int count = 0;
    try {
      OfficeSpreadsheetElement spreadsheetElement = getContentRoot();
      Node child = spreadsheetElement.getFirstChild();
      while ((child != null) && (count <= before)) {
        if (child instanceof TableTableElement) {
          if (count == before) {
            TableTableElement refTableElement = refTable.getOdfElement();
            try {
View Full Code Here
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
    if (index < 0) {
      return;
    }
    int count = 0;
    try {
      OfficeSpreadsheetElement spreadsheetElement = getContentRoot();
      Node child = spreadsheetElement.getFirstChild();
      while ((child != null) && (count <= index)) {
        if (child instanceof TableTableElement) {
          if (count == index) {
            spreadsheetElement.removeChild(child);
            return;
          } else {
            count++;
          }
        }
View Full Code Here
474
475
476
477
478
479
480
481
482
483
484
485
   * @since 0.6
   */
  public int getSheetCount() {
    int count = 0;
    try {
      OfficeSpreadsheetElement spreadsheetElement = getContentRoot();
      Node child = spreadsheetElement.getFirstChild();
      while (child != null) {
        if (child instanceof TableTableElement) {
          count++;
        }
        child = child.getNextSibling();
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
      timefile = new FileInputStream(time_spreadsheet);
      timedoc = OdfDocument.loadDocument(timefile);
    } catch (FileNotFoundException e) {
      //Create an empty spreadsheet
      timedoc = OdfSpreadsheetDocument.newSpreadsheetDocument();
      OfficeSpreadsheetElement spreadsheet = (OfficeSpreadsheetElement) timedoc.getContentDom().getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);
      spreadsheet.removeChild(spreadsheet.getFirstChild());
    }

    try {
      memoryfile = new FileInputStream(memory_spreadsheet);
      memorydoc = OdfDocument.loadDocument(memoryfile);
    } catch (FileNotFoundException e) {
      //Create an empty spreadsheet
      memorydoc = OdfSpreadsheetDocument.newSpreadsheetDocument();
      OfficeSpreadsheetElement spreadsheet = (OfficeSpreadsheetElement) memorydoc.getContentDom().getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);
      spreadsheet.removeChild(spreadsheet.getFirstChild());
    }

    String[] summaryName = new String[]{"Load All Documents", "Parse All Documents", "Save All Documents"};
    updateTableCells(timedoc, "Summary", totalTime, summaryName);
    updateTableCells(timedoc, "Load ODF", totalLoadTimeForEach, TEST_FILE_NAME);
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
    OdfFileDom dom;
    NodeList tableList;
    TableTableElement myTable;
    NodeList lst;
    OdfTextParagraph p;
    OfficeSpreadsheetElement spreadsheet = null;

    try {
      dom = odfdoc.getContentDom();
      tableList = dom.getElementsByTagNameNS(
          OdfDocumentNamespace.TABLE.getUri(), "table");
      spreadsheet = (OfficeSpreadsheetElement) dom.getElementsByTagNameNS(
          OdfDocumentNamespace.OFFICE.getUri(), "spreadsheet").item(0);

      i = 0;
      if (tableList.getLength() > 0) {
        for (; i < tableList.getLength(); i++) {
          String currentname = ((TableTableElement) tableList.item(i)).getTableNameAttribute();
          if (currentname == null) {
            currentname = "";
          }
          if (currentname.equalsIgnoreCase(tablename)) {
            break;
          }
        }
      }
      if (i < tableList.getLength()) //table with the specific table name is found
      {
        myTable = (TableTableElement) tableList.item(i);
      } else { //table with the specific table name is not found. Create table
        myTable = dom.newOdfElement(TableTableElement.class);
        myTable.setTableNameAttribute(tablename);
        spreadsheet.appendChild(myTable);
      }

      lst = myTable.getElementsByTagNameNS(OdfDocumentNamespace.TABLE.getUri(), "table-row");
      if (lst.getLength() == 0) { //the first table row is not existed. Create table row
        td = dom.newOdfElement(TableTableRowElement.class);
View Full Code Here
358
359
360
361
362
363
364
365
366
367
368
369
      OdfFileDom contentDom = odfSpreadSheet.getContentDom();

      NodeList lst = contentDom.getElementsByTagNameNS(
          OfficeSpreadsheetElement.ELEMENT_NAME.getUri(),
          OfficeSpreadsheetElement.ELEMENT_NAME.getLocalName());
      OfficeSpreadsheetElement sheet = (OfficeSpreadsheetElement) lst.item(lst.getLength() - 1);
      TableTableElement table = sheet.newTableTableElement();
      //table.setOdfAttribute( OdfName.newName( OdfNamespace.newName(OdfDocumentNamespace.TABLE), "name" ), "newtable" );
      //table.setOdfAttribute( OdfName.newName( OdfNamespace.newName(OdfDocumentNamespace.TABLE), "style-name" ), "ta1" );
      table.setTableNameAttribute("newtable");
      table.setTableStyleNameAttribute("ta1");
      TableTableColumnElement column = table.newTableTableColumnElement();
View Full Code Here
TOP

Related Classes of org.odftoolkit.odfdom.dom.element.office.OfficeSpreadsheetElement

  • org.odftoolkit.odfdom.doc.CreateChildrenElementsTest
  • org.odftoolkit.odfdom.dom.attribute.table.TableProtectionKeyAttribute
  • org.odftoolkit.odfdom.dom.attribute.table.TableProtectionKeyDigestAlgorithmAttribute
  • org.odftoolkit.odfdom.dom.attribute.table.TableStructureProtectedAttribute
  • org.odftoolkit.odfdom.dom.DefaultElementVisitor
  • org.odftoolkit.odfdom.dom.element.table.TableCalculationSettingsElement
  • org.odftoolkit.odfdom.dom.element.table.TableConsolidationElement
  • org.odftoolkit.odfdom.dom.element.table.TableContentValidationsElement
  • org.odftoolkit.odfdom.dom.element.table.TableDatabaseRangesElement
  • org.odftoolkit.odfdom.dom.element.table.TableDataPilotTablesElement
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.