Examples of CTSst

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

     */
    public void readFrom(InputStream is) throws IOException {
        try {
            int cnt = 0;
            _sstDoc = SstDocument.Factory.parse(is);
            CTSst sst = _sstDoc.getSst();
            count = (int)sst.getCount();
            uniqueCount = (int)sst.getUniqueCount();
            for (CTRst st : sst.getSiArray()) {
                stmap.put(st.toString(), cnt);
                strings.add(st);
                cnt++;
            }
        } catch (XmlException e) {

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

     */
    public void writeTo(OutputStream out) throws IOException {
        XmlOptions options = new XmlOptions(DEFAULT_XML_OPTIONS);


        //re-create the sst table every time saving a workbook
        CTSst sst = _sstDoc.getSst();
        sst.setCount(count);
        sst.setUniqueCount(uniqueCount);


        _sstDoc.save(out, options);
    }

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

    /**
     * Writes the current shared strings table into
     *  the associated OOXML PackagePart
     */
    public void write() throws IOException {
      CTSst sst = doc.getSst();
      
      // Remove the old list
      for(int i=sst.sizeOfSiArray() - 1; i>=0; i--) {
        sst.removeSi(i);
      }
      
      // Add the new one
      for(String s : this) {
        sst.addNewSi().setT(s);
      }
      
      // Update the counts
      sst.setCount(this.size());
      sst.setUniqueCount(this.size());
      
      // Write out
      OutputStream out = part.getOutputStream();
      doc.save(out);
      out.close();

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

    @SuppressWarnings("deprecation") //YK: getXYZArray() array accessors are deprecated in xmlbeans with JDK 1.5 support
    public void readFrom(InputStream is) throws IOException {
        try {
            int cnt = 0;
            _sstDoc = SstDocument.Factory.parse(is);
            CTSst sst = _sstDoc.getSst();
            count = (int)sst.getCount();
            uniqueCount = (int)sst.getUniqueCount();
            for (CTRst st : sst.getSiArray()) {
                stmap.put(getKey(st), cnt);
                strings.add(st);
                cnt++;
            }
        } catch (XmlException e) {

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

        // see Bugzilla 48936
        options.setSaveCDataLengthThreshold(1000000);
        options.setSaveCDataEntityCountThreshold(-1);


        //re-create the sst table every time saving a workbook
        CTSst sst = _sstDoc.getSst();
        sst.setCount(count);
        sst.setUniqueCount(uniqueCount);


        _sstDoc.save(out, options);
    }

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

     * @throws IOException if an error occurs while reading.
     */
    public void readFrom(InputStream is) throws IOException {
        try {
            int cnt = 0;
            CTSst sst = SstDocument.Factory.parse(is).getSst();
            count = (int)sst.getCount();
            uniqueCount = (int)sst.getUniqueCount();
            for (CTRst st : sst.getSiArray()) {
                stmap.put(st.toString(), cnt);
                strings.add(st);
                cnt++;
            }
        } catch (XmlException e) {

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

    public void writeTo(OutputStream out) throws IOException {
        XmlOptions options = new XmlOptions(DEFAULT_XML_OPTIONS);


        //re-create the sst table every time saving a workbook
        SstDocument doc = SstDocument.Factory.newInstance();
        CTSst sst = doc.addNewSst();
        sst.setCount(count);
        sst.setUniqueCount(uniqueCount);


        CTRst[] ctr = strings.toArray(new CTRst[strings.size()]);
        sst.setSiArray(ctr);
        doc.save(out, options);
    }

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

     */
    public void readFrom(InputStream is) throws IOException {
        try {
            int cnt = 0;
            _sstDoc = SstDocument.Factory.parse(is);
            CTSst sst = _sstDoc.getSst();
            count = (int)sst.getCount();
            uniqueCount = (int)sst.getUniqueCount();
            for (CTRst st : sst.getSiArray()) {
                stmap.put(st.toString(), cnt);
                strings.add(st);
                cnt++;
            }
        } catch (XmlException e) {

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

        // see Bugzilla 48936
        options.setSaveCDataLengthThreshold(1000000);
        options.setSaveCDataEntityCountThreshold(-1);


        //re-create the sst table every time saving a workbook
        CTSst sst = _sstDoc.getSst();
        sst.setCount(count);
        sst.setUniqueCount(uniqueCount);


        _sstDoc.save(out, options);
    }

View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

        
        // Requests use of whitespace for easier reading
        options.setSavePrettyPrint();


        SstDocument doc = SstDocument.Factory.newInstance(options);
        CTSst sst = doc.addNewSst();
        sst.setCount(strings.size());
        sst.setUniqueCount(strings.size());
        for (String s : strings) {
            sst.addNewSi().setT(s);
        }
        doc.save(out, options);
    }

View Full Code Here

0 1

TOP

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.