Core Java| JSP| Servlets| XML| EJB| JEE5| Web Services| J2ME| Glossary| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials

Latest Questions
Comments
 
POI API Event 
 

In this program we are going to explain about POI API Event.

 

POI API Event 

                         

In this program we are going to explain about POI API Event.

The advantage of
event API  is that you can read an XLS with a relatively small memory.

To use Event API we construct an instance of org.apache.poi.hssf.eventmodel.HSSFRequest. To register a class we have to create listener org.apache.poi.hssf.eventmodel.HSSFListener interface and use HSSFRequest.addListener(yourlistener, recordsid) method. The record Sid should be a static reference number (such as BOFRecord.sid) contained in the classes in org.apache.poi.hssf.record. Alternatively you can call HSSFRequest.addListenerForAllRecords(mylistener).

Once we have  registered our  listeners in the HSSFRequest object we can construct an instance of org.apache.poi.poifs.filesystem.FileSystem and pass it your XLS file inputstream. We can either pass this, along with the request we constructed, to an instance of HSSFEventFactory via the HSSFEventFactory.processWorkbookEvents(request, Filesystem) method, or we can get an instance of DocumentInputStream from Filesystem.createDocumentInputStream("Workbook") and pass it to HSSFEventFactory.processEvents(request, inputStream). Once we make this call, the listeners that we constructed receive calls to their processRecord(Record) methods with each Record they are registered to listen for until the file has been completely read.
 
 The code of the program is given below:
import java.io.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.*;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.eventusermodel.*;
import org.apache.poi.hssf.record.*;
import org.apache.poi.hssf.dev.EFHSSF;
public class EventAPIsExample implements HSSFListener
{   
public static void main(String[] argsthrows IOException
    
  
FileInputStream fin = new FileInputStream("example.xls");
  POIFSFileSystem poifs = new POIFSFileSystem(fin);
        InputStream din = poifs.createDocumentInputStream
(
"Workbook");
        HSSFRequest req = new HSSFRequest();
        req.addListenerForAllRecords(new EventAPIsExample());
        HSSFEventFactory factory = new HSSFEventFactory();
    System.out.println("\n\nExample of Event
 API using POI3.0)\n\n"
);
        factory.processEvents(req, din);
        fin.close();
        din.close();
        System.out.println("\n\nIn main method ->>
public static void main(String[] args)"
);
    }
  public void processRecord(Record record)
    {
        
       System.out.println("In Processs method ->>
public void processRecord(Record record)"
);
    }
}

The output of the program is given below:

C:\POI3.0\exmples\execl>javac EventAPIsExample.java

C:\POI3.0\exmples\execl>java EventAPIsExample example.xls

Example of Event API using POI3.0)

In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)
In Processs method ->>public void processRecord(Record record)

In main method ->>public static void main(String[] args)

C:\POI3.0\exmples\execl>

 

Download this example.

                         

» View all related tutorials
Related Tags: c api class static script event io methods method variable sed find get type hex ip operator using ria this

Leave your comment:

Name:

Email:

URL:

Title:

Comments:


Enter Code:

Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Software Solutions
Least Viewed
Most Rated
Recently Viewed
Search Tutorials

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.