You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Parag Kalra <pa...@gmail.com> on 2010/06/13 08:21:44 UTC

First time Queries on Apache - POI

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

Re: First time Queries on Apache - POI

Posted by David Fisher <df...@jmlafferty.com>.
> 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.

Yegor and I live on Solaris and have no trouble.

Regards,
Dave


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


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

Re: First time Queries on Apache - POI

Posted by MSB <ma...@tiscali.co.uk>.
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