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

Package org.apache.poi.hssf.eventusermodel

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

org.apache.poi.hssf.eventusermodel.HSSFEventFactory
Low level event based HSSF reader. Pass either a DocumentInputStream to process events along with a request object or pass a POIFS POIFSFileSystem to processWorkbookEvents along with a request. This will cause your file to be processed a record at a time. Each record with a static id matching one that you have registed in your HSSFRequest will be passed to your associated HSSFListener. @see org.apache.poi.hssf.dev.EFHSSF @author Andrew C. Oliver (acoliver at apache dot org) @author Carey Sublette (careysub@earthling.net)

                //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!)
                din.close();
                
                //now the parsed strings are in the StringBuilder, now convert them to a String
                final String contents = sbFoundStrings.toString().trim();

View Full Code Here

            // get the Workbook (excel part) stream in a InputStream
            din = poifs.createDocumentInputStream( WORKBOOK );
            HSSFRequest req = new HSSFRequest( );
            // lazy listen for ALL records with the listener shown above
            req.addListenerForAllRecords( this );
            HSSFEventFactory factory = new HSSFEventFactory( );
            factory.processEvents( req,
                                   din );
        }
        catch ( IOException ex )
        {
            throw new DecisionTableParseException( "Failed to open Excel stream, " +

View Full Code Here

            public void processRecord(Record rec)
            {
                System.out.println(rec.toString());
            }
        });
        HSSFEventFactory factory = new HSSFEventFactory();


        factory.processEvents(req, din);
    }

View Full Code Here

                hssfRequest.addListener(formatListener, ExtendedFormatRecord.sid);
            }


            // Create event factory and process Workbook (fire events)
            DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
            HSSFEventFactory eventFactory = new HSSFEventFactory();
            eventFactory.processEvents(hssfRequest, documentInputStream);
      }

View Full Code Here

            hssfRequest.addListener(listener, RKRecord.sid);
        }


        // Create event factory and process Workbook (fire events)
        DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
        HSSFEventFactory eventFactory = new HSSFEventFactory();
        eventFactory.processEvents(hssfRequest, documentInputStream);


        if (log.isInfoEnabled()) {
            log.info("Processed " + listener.getRecordCount() + " records");
        }
    }

View Full Code Here

        // 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
        fin.close();
        // and our document input stream (don't want to leak these!)
        din.close();
        System.out.println("done.");

View Full Code Here

        // 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
        fin.close();
        // and our document input stream (don't want to leak these!)
        din.close();
        System.out.println("done.");

View Full Code Here

    /* 
     * @see com.common.platform.excel.parser.ExcelDataParser#parser(java.lang.String)
     */
    @Override
    public void parser(String fileName) throws Throwable {
        HSSFEventFactory factory = new HSSFEventFactory();
        HSSFRequest request = new HSSFRequest();


        // 建立监听器
        MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
        formatListener = new FormatTrackingHSSFListener(listener);
        
        if (outputFormulaValues) {
            request.addListenerForAllRecords(formatListener);
        } else {
            workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
            request.addListenerForAllRecords(workbookBuildingListener);
        }
        
        // 解析文件并处理监听请求
        POIFSFileSystem poiFile = new POIFSFileSystem(new FileInputStream(fileName));
        factory.processWorkbookEvents(request, poiFile);
    }

View Full Code Here

    TextListener tl = new TextListener();
    FormatTrackingHSSFListener ft = new FormatTrackingHSSFListener(tl);
    tl.ft = ft;


    // Register and process
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(ft);


    factory.processWorkbookEvents(request, fs);


    return tl;
  }

View Full Code Here

            hssfRequest.addListener(listener, TextObjectRecord.sid);
        }


        // Create event factory and process Workbook (fire events)
        DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
        HSSFEventFactory eventFactory = new HSSFEventFactory();


        eventFactory.processEvents(hssfRequest, documentInputStream);
        listener.throwStoredException();
    }

View Full Code Here

0 1 2 3 4 5 6

TOP

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

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.TestHSSFEventFactory

org.apache.poi.hssf.eventusermodel.TestMissingRecordAwareHSSFListener

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.