Package org.apache.poi.hssf.eventusermodel

Examples of org.apache.poi.hssf.eventusermodel.HSSFRequest

222
223
224
225
226
227
228
229
230
231
232
233
234
235
            // 创建 org.apache.poi.poifs.filesystem.Filesystem
            POIFSFileSystem poifs = new POIFSFileSystem(bis);
            // 从输入流 得到 Workbook(excel 部分)流
            dis = poifs.createDocumentInputStream("Workbook");
            // 构造 HSSFRequest
            HSSFRequest req = new HSSFRequest();

            // 添加监听器
            req.addListenerForAllRecords(new Excel2003ImportListener(proxy, dataList, batchSize));
            //  创建事件工厂
            HSSFEventFactory factory = new HSSFEventFactory();
            // 根据文档输入流处理事件
            factory.processEvents(req, dis);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
  }

  public void testAbortingBasics() throws Exception {
    AbortableCountingListener l = new AbortableCountingListener(1000);

    HSSFRequest req = new HSSFRequest();
    req.addListenerForAllRecords(l);

    HSSFEventFactory f = new HSSFEventFactory();

    assertEquals(0, l.countSeen);
    assertEquals(null, l.lastRecordSeen);
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78

  public void testAbortStops() throws Exception {
    AbortableCountingListener l = new AbortableCountingListener(1);

    HSSFRequest req = new HSSFRequest();
    req.addListenerForAllRecords(l);

    HSSFEventFactory f = new HSSFEventFactory();

    assertEquals(0, l.countSeen);
    assertEquals(null, l.lastRecordSeen);
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    formatListener = new FormatTrackingHSSFListener(listener);

    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();

    if(outputFormulaValues) {
      request.addListenerForAllRecords(formatListener);
    } else {
      workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
      request.addListenerForAllRecords(workbookBuildingListener);
    }

    factory.processWorkbookEvents(request, fs);
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
        // create a new org.apache.poi.poifs.filesystem.Filesystem
        POIFSFileSystem poifs = new POIFSFileSystem(fin);
        // get the Workbook (excel part) stream in a InputStream
        InputStream din = poifs.createDocumentInputStream("Workbook");
        // construct out HSSFRequest object
        HSSFRequest req = new HSSFRequest();
        // lazy listen for ALL records with the listener shown above
        req.addListenerForAllRecords(new EventExample());
        // create our event factory
        HSSFEventFactory factory = new HSSFEventFactory();
        // process our events based on the document input stream
        factory.processEvents(req, din);
        // once all the events are processed close our file input stream
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    formatListener = new FormatTrackingHSSFListener(listener);

    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();

    if(outputFormulaValues) {
      request.addListenerForAllRecords(formatListener);
    } else {
      workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
      request.addListenerForAllRecords(workbookBuildingListener);
    }

    factory.processWorkbookEvents(request, fs);
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
   * Initiates the processing of the XLS file to CSV
   */
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(listener);

    factory.processWorkbookEvents(request, fs);
  }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
   * Initiates the processing of the XLS file to CSV
   */
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(listener);
   
    factory.processWorkbookEvents(request, fs);
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
105
                //create a new org.apache.poi.poifs.filesystem.Filesystem
                final POIFSFileSystem poifs = new POIFSFileSystem(source);
                //get the Workbook (excel part) stream in a InputStream
                final InputStream din = poifs.createDocumentInputStream("Workbook");
                //construct out HSSFRequest object
                final HSSFRequest req = new HSSFRequest();
                //lazy listen for ALL records with the listener shown above
                req.addListenerForAllRecords(this);
                //create our event factory
                final HSSFEventFactory factory = new HSSFEventFactory();
                //process our events based on the document input stream
                factory.processEvents(req, din);
                //close our document input stream (don't want to leak these!)
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
    protected void initWorkbookAndSheet(final int startRowNumber) throws Exception {
        queue = new ArrayBlockingQueue<Object>(queueCapacity == 0 ? MAX_WORKSHEET_ROWS : queueCapacity);
        final POIFSFileSystem poifs = new POIFSFileSystem(inputStream);
        // get the Workbook (excel part) stream in a InputStream
        documentInputStream = poifs.createDocumentInputStream("Workbook");
        final HSSFRequest req = new HSSFRequest();
        final MissingRecordAwareHSSFListener missingRecordAwareHSSFListener = new MissingRecordAwareHSSFListener(new HSSFListenerImpl(this));
        formatListener = new FormatTrackingHSSFListener(missingRecordAwareHSSFListener);
        req.addListenerForAllRecords(formatListener);
        final HSSFEventFactory factory = new HSSFEventFactory();

        if (objectMapper == null) {
            initJsonFactoryAndObjectMapper();
        }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.eventusermodel.HSSFRequest

  • com.common.platform.excel.parser.HSSFParser
  • com.sishuok.es.showcase.excel.service.ExcelDataService
  • evolaris.framework.sys.business.XLS2CSVmra
  • net.yacy.document.parser.xlsParser$XLSHSSFListener
  • org.apache.poi.hssf.dev.EFBiffViewer
  • org.apache.poi.hssf.dev.EFHSSF
  • org.apache.poi.hssf.eventmodel.TestAbortableListener
  • org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
  • org.apache.poi.hssf.eventusermodel.TestMissingRecordAwareHSSFListener
  • org.apache.poi.hssf.extractor.EventBasedExcelExtractor
    • 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.