poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: First time Queries on Apache - POI
Date Sun, 13 Jun 2010 06:42:37 GMT

Hello Parag,

1, Yes you can. It will be best to write code that targets the classes in
the SS usermodel package as this will allow you to seamlessly process both
file types. There are a few examples of how to do this - and if you are at
all unclear of course, just post a question to this list - but you will
basically be creating code that uses top level classes such as Workbook,
Sheet, Row, Cell, CellStyle, etc that are shored by both the HSSF and XSSF
streams. There are no real complications to this, it does future proof your
code to some extent and it removes the need to maintain two different code
bases.

2. Yes, it should simply be a matter of making the archives avaliable to the
code at compile time and at runtime by setting your classpath appropriately.
I do not have the complete list of archives that you will need to reference
to hand at the moment but this has apperaed in quite a few posts and you
will soon find out what you need as you start to compile and run some code.

3e. Sorry, I cannot answer this question as I have no experience whatsoever
of Solaris. Having siad that, I would not expect you to need anything extra
as the releases usually include all of the necessary dependencies - xmlbeans
and the like.

Yours

Mark B


paragkalra wrote:
> 
> Hi All,
> 
> I am soon planning to use Apache - POI to process excel sheets. I have
> following queries on it.
> 
> 1. Can it process both xls and xlsx excel sheets.
> 2. I intend to use it on solaris having JDK 1.6 available. I have
> downloaded
> the package Apache - POI containing Jar files. So I believe I just need to
> include those in my code to process the excel sheets. Kindly correct me if
> I
> am wrong.
> 3. Is there any other dependency to be able to use it on Solaris.
> 
> Cheers,
> Parag
> 
> 

-- 
View this message in context: http://old.nabble.com/First-time-Queries-on-Apache---POI-tp28869368p28869426.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message