You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Ramon Nogueira <ra...@gmail.com> on 2007/03/17 17:45:18 UTC
Stealing outline code from Perl SpreadSheet::WriteExcel
Hi,
I am working on an application for which I need to generate Excel
spreadsheets with outlining. I read in the Limitations section on the
HSSF website that this is not possible at the moment. I have found a
Perl module, SpreadSheet::WriteExcel (on CPAN), that does exactly what
I want.
Unfortunately (in this respect), I'm not using Perl for this project
but Java. It is easy enough for me to write a Perl script, pass the
data from Java to Perl through some IPC mechanism, and then pass the
resulting spreadsheet back. However, it would be much more satisfying
if I could do this all in Java with HSSF.
What are the issues with porting the outlining code from Perl as
regards licensing? If they are surmountable, I would definitely be
willing to spend some time doing it (with the guidance of the HSSF
developers).
Regards
Ramon
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
Re: Stealing outline code from Perl SpreadSheet::WriteExcel
Posted by Yegor Kozlov <ye...@dinom.ru>.
Hi,
HSSF supports outlining. Look at
http://jakarta.apache.org/poi/hssf/quick-guide.html#Outlining
Is it what you need? What version of POI are you using?
Try the latest POI 3.0 release candidate. This can be downloaded from:
http://people.apache.org/~nick/POI-3.0-RC1/
Regards,
Yegor
RN> Hi,
RN> I am working on an application for which I need to generate Excel
RN> spreadsheets with outlining. I read in the Limitations section on the
RN> HSSF website that this is not possible at the moment. I have found a
RN> Perl module, SpreadSheet::WriteExcel (on CPAN), that does exactly what
RN> I want.
RN> Unfortunately (in this respect), I'm not using Perl for this project
RN> but Java. It is easy enough for me to write a Perl script, pass the
RN> data from Java to Perl through some IPC mechanism, and then pass the
RN> resulting spreadsheet back. However, it would be much more satisfying
RN> if I could do this all in Java with HSSF.
RN> What are the issues with porting the outlining code from Perl as
RN> regards licensing? If they are surmountable, I would definitely be
RN> willing to spend some time doing it (with the guidance of the HSSF
RN> developers).
RN> Regards
RN> Ramon
RN> ---------------------------------------------------------------------
RN> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
RN> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
RN> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
Re: Stealing outline code from Perl SpreadSheet::WriteExcel
Posted by Ramon Nogueira <ra...@gmail.com>.
Thanks, haven't tried it out yet but this looks to be exactly what I
need! Congratulations on a truly useful product!
Ramon Nogueira
On 3/20/07, Yegor Kozlov <ye...@dinom.ru> wrote:
> The Limitations doc page is old. It lists POI 2.0 limitations.
> Rich Text and Outlines are supported since POI 2.5. I'm going to
> update the limitations list.
>
> Regards,
> Yegor
>
> RN> Hi,
>
> RN> I am working on an application for which I need to generate Excel
> RN> spreadsheets with outlining. I read in the Limitations section on the
> RN> HSSF website that this is not possible at the moment. I have found a
> RN> Perl module, SpreadSheet::WriteExcel (on CPAN), that does exactly what
> RN> I want.
>
> RN> Unfortunately (in this respect), I'm not using Perl for this project
> RN> but Java. It is easy enough for me to write a Perl script, pass the
> RN> data from Java to Perl through some IPC mechanism, and then pass the
> RN> resulting spreadsheet back. However, it would be much more satisfying
> RN> if I could do this all in Java with HSSF.
>
> RN> What are the issues with porting the outlining code from Perl as
> RN> regards licensing? If they are surmountable, I would definitely be
> RN> willing to spend some time doing it (with the guidance of the HSSF
> RN> developers).
>
> RN> Regards
> RN> Ramon
>
> RN> ---------------------------------------------------------------------
> RN> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> RN> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> RN> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
Re: Stealing outline code from Perl SpreadSheet::WriteExcel
Posted by Yegor Kozlov <ye...@dinom.ru>.
The Limitations doc page is old. It lists POI 2.0 limitations.
Rich Text and Outlines are supported since POI 2.5. I'm going to
update the limitations list.
Regards,
Yegor
RN> Hi,
RN> I am working on an application for which I need to generate Excel
RN> spreadsheets with outlining. I read in the Limitations section on the
RN> HSSF website that this is not possible at the moment. I have found a
RN> Perl module, SpreadSheet::WriteExcel (on CPAN), that does exactly what
RN> I want.
RN> Unfortunately (in this respect), I'm not using Perl for this project
RN> but Java. It is easy enough for me to write a Perl script, pass the
RN> data from Java to Perl through some IPC mechanism, and then pass the
RN> resulting spreadsheet back. However, it would be much more satisfying
RN> if I could do this all in Java with HSSF.
RN> What are the issues with porting the outlining code from Perl as
RN> regards licensing? If they are surmountable, I would definitely be
RN> willing to spend some time doing it (with the guidance of the HSSF
RN> developers).
RN> Regards
RN> Ramon
RN> ---------------------------------------------------------------------
RN> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
RN> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
RN> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/