Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Find Name of Excel Sheet

In this program we are going to find the name of an excel sheet using POI3.0 API Event.

Tutorial Details:

In this program we are going to find the name of an excel sheet using POI3.0 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).


 

Rate Tutorial:
http://www.roseindia.net/java/poi/FindNameOfSheet.shtml

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Find Name of Excel Sheet

View Tutorial:
Find Name of Excel Sheet

Related Tutorials:

Accelerate your Java apps! - JavaWorld - September 1998
Accelerate your Java apps! - JavaWorld - September 1998
 
XML JavaBeans, Part 1 - JavaWorld February 1999
XML JavaBeans, Part 1 - JavaWorld February 1999
 
Problems with Swing's new XMLOutputStream class - JavaWorld August 1999
Problems with Swing's new XMLOutputStream class - JavaWorld August 1999
 
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
 
Printing in Java, Part 2 - JavaWorld December 2000
Printing in Java, Part 2 - JavaWorld December 2000
 
UDDI4J lets Java do the walking
UDDI4J lets Java do the walking
 
Think small: Java on Compaq's iPAQ
Think small: Java on Compaq's iPAQ
 
Container-managed relations for the 21st century
Container-managed relations for the 21st century
 
Score big with JSR 77, the J2EE Management Specification
Score big with JSR 77, the J2EE Management Specification
 
Publish and find UDDI tModels with JAXR and WSDL
Publish and find UDDI tModels with JAXR and WSDL
 
Smartly load your properties
Smartly load your properties
 
Good ideas
Good ideas
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
Seven Low-Cost Ways to Improve Legacy Code
This article presents seven techniques I\'ve developed and used in my consulting work that are designed to improve legacy code.
 
The HTML Renderer Shootout, Part 1
The HTML Renderer Shootout, Part 1 In this article, we will review 11 different HTML renderers, comparing their features, compliance, and speed; searching for the best one for any project.
 
They just work
Writing CSV files: CSVPrinter This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
 
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
 
Complete Webhosting Guide, Search Web hosts, Find Plans
Complete Webhosting Guide, Search Web hosts, Find Plans The Complete Web Hosting Guide RoseIndia.net is the complete beginner's guide to finding a web hosting company. Introduction to Web Hosting What is Web Hosting? Linux vs. Windows
 
Web Hosting Guide. Introduction to Domain Name
Web Hosting Guide. Introduction to Domain Name Introduction to Domain Name What is Domain Name? If we have to send a letter to someone, we must know his/her mailing address. In the same way if we want to visit a website, we also need to know its
 
Site navigation
 

 

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

Copyright © 2006. All rights reserved.