Package org.apache.poi.hssf.model

Examples of org.apache.poi.hssf.model.SharedStringsTable


    workbookDoc =
      WorkbookDocument.Factory.parse(basePart.getInputStream());
   
    PackagePart ssPart = getSinglePartByRelationType(SHARED_STRINGS_RELATION_TYPE, basePart);
    if (ssPart != null) {
      sharedStrings = new SharedStringsTable(ssPart);
    } else {
     
    }
  }
View Full Code Here


    HSSFXML xml = new HSSFXML(
        HXFDocument.openPackage(sampleFile)
    );
    assertNotNull(xml._getSharedStringsTable());
   
    SharedStringsTable sst = xml._getSharedStringsTable();
    assertEquals(10, sst.size());
   
    assertEquals("Lorem", sst.get(0));
    for(int i=0; i<sst.size(); i++) {
      assertEquals(sst.get(i), xml.getSharedString(i));
    }
   
    // Add a few more, then save and reload, checking
    //  changes have been kept
    sst.add("Foo");
    sst.add("Bar");
    sst.set(0, "LoremLorem");
   
    sst.write();
   
    xml = new HSSFXML(xml.getPackage());
    sst = xml._getSharedStringsTable();
    assertEquals(12, sst.size());
   
    assertEquals("LoremLorem", sst.get(0));
    for(int i=0; i<sst.size(); i++) {
      assertEquals(sst.get(i), xml.getSharedString(i));
    }
  }
View Full Code Here

TOP

Related Classes of org.apache.poi.hssf.model.SharedStringsTable

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.