Package org.openxmlformats.schemas.spreadsheetml.x2006.main

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

105
106
107
108
109
110
111
112
113
114
115
116
117
118
     */
    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
195
196
197
198
199
200
201
202
203
204
205
     */
    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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
    /**
     * 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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
    @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
213
214
215
216
217
218
219
220
221
222
223
        // 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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
     * @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
187
188
189
190
191
192
193
194
195
196
197
198
199
    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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
     */
    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
199
200
201
202
203
204
205
206
207
208
209
        // 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
108
109
110
111
112
113
114
115
116
117
118
119
120
       
        // 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
TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst

  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.poi.hssf.extractor.HXFExcelExtractor
  • org.apache.poi.hssf.HSSFXML
  • org.apache.poi.hssf.model.SharedStringsTable
  • org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.model.CommentsTable
  • org.apache.poi.xssf.model.Control
  • org.apache.poi.xssf.model.Drawing
  • org.apache.poi.xssf.model.ExternalLinksTable
    • 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.