You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@myfaces.apache.org by Cagatay Civici <ca...@gmail.com> on 2006/08/23 10:21:34 UTC

Excel Export for Extended Datatable

Hi,

I've created a new feature for the datatable that allows exporting presented
data to the excel format.

Simply an excel button is placed on the datatable header and clicking on it
makes an ajax request, a popup is displayed and excel file is presented.

Following are the two screenshots;

http://img206.imageshack.us/my.php?image=table17gs.jpg
http://img80.imageshack.us/img80/3568/table7xm.jpg

This was a requirement needed in my last project, I think it would also be
useful if I integrate this for our extended datatable with an attribute.

What do you think?

Cagatay

Re: Excel Export for Extended Datatable

Posted by Cagatay Civici <ca...@gmail.com>.

Yes I agree with you Jurgen.

But It seems we don't know how far this exporting business will go. My plan
is to work at sandbox for now, when the time comes to do the promotion, I
guess we'll have a better understanding of the situation.

Cagatay

On 8/24/06, Jurgen Lust <Ju...@gmail.com> wrote:
>
> > I think this situation is similar to the commons-fileupload dependency
> > of the file upload component. I dont quite get the subproject idea
> > Jurgen, can you explain it more? How is it gonna be distributed?
>
> Well, there have been questions on the iText mailing list about
> rendering PDF from JSF components. I think we had a brief discussion
> about this here as well some time ago. There are quite a few components
> that would be candidates for pdf rendering, and some of them, like the
> datatable, also for Excel or ODF or CSV rendering. So you could create
> the s:excelExporter, s:pdfExporter, etc. components, but then you have
> to introduce POI, iText, etc. as dependencies to Tomahawk.
>
> You could create a new subproject alongside tomahawk, tobago and
> trinidad, that just handles export of component data to these other
> formats. That would also allow people who don't use tomahawk to use
> those export buttons.
>
> I don't know, perhaps the functionality is too limited for a new
> subproject, it's just that when you start introducing things like POI as
> dependency for Tomahawk, where will it stop? Not that I have anything
> against POI, I'm using it myself and I'm very happy with it :)
>
> Jurgen
>
>
>

Re: Excel Export for Extended Datatable

Posted by Jurgen Lust <Ju...@gmail.com>.

> I think this situation is similar to the commons-fileupload dependency
> of the file upload component. I dont quite get the subproject idea
> Jurgen, can you explain it more? How is it gonna be distributed?

Well, there have been questions on the iText mailing list about
rendering PDF from JSF components. I think we had a brief discussion
about this here as well some time ago. There are quite a few components
that would be candidates for pdf rendering, and some of them, like the
datatable, also for Excel or ODF or CSV rendering. So you could create
the s:excelExporter, s:pdfExporter, etc. components, but then you have
to introduce POI, iText, etc. as dependencies to Tomahawk.

You could create a new subproject alongside tomahawk, tobago and
trinidad, that just handles export of component data to these other
formats. That would also allow people who don't use tomahawk to use
those export buttons. 

I don't know, perhaps the functionality is too limited for a new
subproject, it's just that when you start introducing things like POI as
dependency for Tomahawk, where will it stop? Not that I have anything
against POI, I'm using it myself and I'm very happy with it :)

Jurgen

Re: Excel Export for Extended Datatable

Posted by Martin Marinschek <ma...@gmail.com>.

I don't know - how large is POI? Generally speaking, many users do
work with POI, so it might not be as large a problem, especially with
Maven.

(it wouldn't be the implementation which would come along with it,
only tomahawk)

regards,

Martin

On 8/24/06, Cagatay Civici <ca...@gmail.com> wrote:
>
> > What library will you use to generate the Excel output? POI?
> >
>
>  Yes POI.
>
>
>
> > Should we really make this a dependency for Tomahawk? I think it would
> > be better to put it in a different subproject. Some kind of
> > ExportRenderKit, which could also contain PDF renderers using iText, for
> > example.
>
>  I think this situation is similar to the commons-fileupload dependency of
> the file upload component. I dont quite get the subproject idea Jurgen, can
> you explain it more? How is it gonna be distributed?
>
>  Cagatay
>
>
> On 8/24/06, Jurgen Lust <Ju...@gmail.com> wrote:
> > What library will you use to generate the Excel output? POI?
> > Should we really make this a dependency for Tomahawk? I think it would
> > be better to put it in a different subproject. Some kind of
> > ExportRenderKit, which could also contain PDF renderers using iText, for
> > example.
> >
> > Jurgen
> >
> > Op wo, 23-08-2006 te 17:44 +0000, schreef Martin Marinschek:
> > > Yeah, exactly.
> > >
> > > If that works, I'd fancy it a lot more!
> > >
> > > regards,
> > >
> > > Martin
> > >
> > > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > > Hi Martin,
> > > >
> > > > Yes that seems like a better idea, so something like this one right?
> > > >
> > > > <t:datatable id="tableId">
> > > > ...
> > > > ...
> > > > ...
> > > > </t:datatable>
> > > >
> > > > <s:excelExporter for="tableId" />
> > > >
> > > > This would render a button and onclick exports the datatable data to
> excel
> > > > format.
> > > >
> > > > Cagatay
> > > >
> > > >
> > > > On 8/23/06, Martin Marinschek < martin.marinschek@gmail.com> wrote:
> > > > > Hmm... My problem with our extended data-table is that it is much
> > > > > toooo overweight already. Couldn't we work with an extra component
> > > > > here, which has a for-attribute referencing a dataTable-component,
> and
> > > > > displays the button and on click the excel data for the dataTable?
> > > > >
> > > > > regards,
> > > > >
> > > > > Martin
> > > > >
> > > > > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > > > > Hi,
> > > > > >
> > > > > > I've created a new feature for the datatable that allows exporting
> > > > presented
> > > > > > data to the excel format.
> > > > > >
> > > > > > Simply an excel button is placed on the datatable header and
> clicking on
> > > > it
> > > > > > makes an ajax request, a popup is displayed and excel file is
> presented.
> > > > > >
> > > > > > Following are the two screenshots;
> > > > > >
> > > > > >
> http://img206.imageshack.us/my.php?image=table17gs.jpg
> > > > > >
> http://img80.imageshack.us/img80/3568/table7xm.jpg
> > > > > >
> > > > > > This was a requirement needed in my last project, I think it would
> also
> > > > be
> > > > > > useful if I integrate this for our extended datatable with an
> attribute.
> > > > > >
> > > > > > What do you think?
> > > > > >
> > > > > > Cagatay
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > http://www.irian.at
> > > > >
> > > > > Your JSF powerhouse -
> > > > > JSF Consulting, Development and
> > > > > Courses in English and German
> > > > >
> > > > > Professional Support for Apache MyFaces
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


-- 

http://www.irian.at

Your JSF powerhouse -
JSF Consulting, Development and
Courses in English and German

Professional Support for Apache MyFaces

Re: Excel Export for Extended Datatable

Posted by Cagatay Civici <ca...@gmail.com>.

>
> What library will you use to generate the Excel output? POI?
>

Yes POI.

Should we really make this a dependency for Tomahawk? I think it would
> be better to put it in a different subproject. Some kind of
> ExportRenderKit, which could also contain PDF renderers using iText, for
> example.


I think this situation is similar to the commons-fileupload dependency of
the file upload component. I dont quite get the subproject idea Jurgen, can
you explain it more? How is it gonna be distributed?

Cagatay

On 8/24/06, Jurgen Lust <Ju...@gmail.com> wrote:
>
> What library will you use to generate the Excel output? POI?
> Should we really make this a dependency for Tomahawk? I think it would
> be better to put it in a different subproject. Some kind of
> ExportRenderKit, which could also contain PDF renderers using iText, for
> example.
>
> Jurgen
>
> Op wo, 23-08-2006 te 17:44 +0000, schreef Martin Marinschek:
> > Yeah, exactly.
> >
> > If that works, I'd fancy it a lot more!
> >
> > regards,
> >
> > Martin
> >
> > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > Hi Martin,
> > >
> > > Yes that seems like a better idea, so something like this one right?
> > >
> > > <t:datatable id="tableId">
> > > ...
> > > ...
> > > ...
> > > </t:datatable>
> > >
> > > <s:excelExporter for="tableId" />
> > >
> > > This would render a button and onclick exports the datatable data to
> excel
> > > format.
> > >
> > > Cagatay
> > >
> > >
> > > On 8/23/06, Martin Marinschek < martin.marinschek@gmail.com> wrote:
> > > > Hmm... My problem with our extended data-table is that it is much
> > > > toooo overweight already. Couldn't we work with an extra component
> > > > here, which has a for-attribute referencing a dataTable-component,
> and
> > > > displays the button and on click the excel data for the dataTable?
> > > >
> > > > regards,
> > > >
> > > > Martin
> > > >
> > > > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > > > Hi,
> > > > >
> > > > > I've created a new feature for the datatable that allows exporting
> > > presented
> > > > > data to the excel format.
> > > > >
> > > > > Simply an excel button is placed on the datatable header and
> clicking on
> > > it
> > > > > makes an ajax request, a popup is displayed and excel file is
> presented.
> > > > >
> > > > > Following are the two screenshots;
> > > > >
> > > > > http://img206.imageshack.us/my.php?image=table17gs.jpg
> > > > >  http://img80.imageshack.us/img80/3568/table7xm.jpg
> > > > >
> > > > > This was a requirement needed in my last project, I think it would
> also
> > > be
> > > > > useful if I integrate this for our extended datatable with an
> attribute.
> > > > >
> > > > > What do you think?
> > > > >
> > > > > Cagatay
> > > > >
> > > >
> > > >
> > > > --
> > > >
> > > > http://www.irian.at
> > > >
> > > > Your JSF powerhouse -
> > > > JSF Consulting, Development and
> > > > Courses in English and German
> > > >
> > > > Professional Support for Apache MyFaces
> > > >
> > >
> > >
> >
> >
>
>

Re: Excel Export for Extended Datatable

Posted by Jurgen Lust <Ju...@gmail.com>.

What library will you use to generate the Excel output? POI?
Should we really make this a dependency for Tomahawk? I think it would
be better to put it in a different subproject. Some kind of
ExportRenderKit, which could also contain PDF renderers using iText, for
example.

Jurgen

Op wo, 23-08-2006 te 17:44 +0000, schreef Martin Marinschek:
> Yeah, exactly.
> 
> If that works, I'd fancy it a lot more!
> 
> regards,
> 
> Martin
> 
> On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > Hi Martin,
> >
> > Yes that seems like a better idea, so something like this one right?
> >
> > <t:datatable id="tableId">
> > ...
> > ...
> > ...
> > </t:datatable>
> >
> > <s:excelExporter for="tableId" />
> >
> > This would render a button and onclick exports the datatable data to excel
> > format.
> >
> > Cagatay
> >
> >
> > On 8/23/06, Martin Marinschek < martin.marinschek@gmail.com> wrote:
> > > Hmm... My problem with our extended data-table is that it is much
> > > toooo overweight already. Couldn't we work with an extra component
> > > here, which has a for-attribute referencing a dataTable-component, and
> > > displays the button and on click the excel data for the dataTable?
> > >
> > > regards,
> > >
> > > Martin
> > >
> > > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > > Hi,
> > > >
> > > > I've created a new feature for the datatable that allows exporting
> > presented
> > > > data to the excel format.
> > > >
> > > > Simply an excel button is placed on the datatable header and clicking on
> > it
> > > > makes an ajax request, a popup is displayed and excel file is presented.
> > > >
> > > > Following are the two screenshots;
> > > >
> > > > http://img206.imageshack.us/my.php?image=table17gs.jpg
> > > >  http://img80.imageshack.us/img80/3568/table7xm.jpg
> > > >
> > > > This was a requirement needed in my last project, I think it would also
> > be
> > > > useful if I integrate this for our extended datatable with an attribute.
> > > >
> > > > What do you think?
> > > >
> > > > Cagatay
> > > >
> > >
> > >
> > > --
> > >
> > > http://www.irian.at
> > >
> > > Your JSF powerhouse -
> > > JSF Consulting, Development and
> > > Courses in English and German
> > >
> > > Professional Support for Apache MyFaces
> > >
> >
> >
> 
>

Re: Excel Export for Extended Datatable

Posted by Martin Marinschek <ma...@gmail.com>.

Yeah, exactly.

If that works, I'd fancy it a lot more!

regards,

Martin

On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> Hi Martin,
>
> Yes that seems like a better idea, so something like this one right?
>
> <t:datatable id="tableId">
> ...
> ...
> ...
> </t:datatable>
>
> <s:excelExporter for="tableId" />
>
> This would render a button and onclick exports the datatable data to excel
> format.
>
> Cagatay
>
>
> On 8/23/06, Martin Marinschek < martin.marinschek@gmail.com> wrote:
> > Hmm... My problem with our extended data-table is that it is much
> > toooo overweight already. Couldn't we work with an extra component
> > here, which has a for-attribute referencing a dataTable-component, and
> > displays the button and on click the excel data for the dataTable?
> >
> > regards,
> >
> > Martin
> >
> > On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > > Hi,
> > >
> > > I've created a new feature for the datatable that allows exporting
> presented
> > > data to the excel format.
> > >
> > > Simply an excel button is placed on the datatable header and clicking on
> it
> > > makes an ajax request, a popup is displayed and excel file is presented.
> > >
> > > Following are the two screenshots;
> > >
> > > http://img206.imageshack.us/my.php?image=table17gs.jpg
> > >  http://img80.imageshack.us/img80/3568/table7xm.jpg
> > >
> > > This was a requirement needed in my last project, I think it would also
> be
> > > useful if I integrate this for our extended datatable with an attribute.
> > >
> > > What do you think?
> > >
> > > Cagatay
> > >
> >
> >
> > --
> >
> > http://www.irian.at
> >
> > Your JSF powerhouse -
> > JSF Consulting, Development and
> > Courses in English and German
> >
> > Professional Support for Apache MyFaces
> >
>
>


-- 

http://www.irian.at

Your JSF powerhouse -
JSF Consulting, Development and
Courses in English and German

Professional Support for Apache MyFaces

Re: Excel Export for Extended Datatable

Posted by Cagatay Civici <ca...@gmail.com>.

Hi Martin,

Yes that seems like a better idea, so something like this one right?

<t:datatable id="tableId">
...
...
...
</t:datatable>

<s:excelExporter for="tableId" />

This would render a button and onclick exports the datatable data to excel
format.

Cagatay

On 8/23/06, Martin Marinschek <ma...@gmail.com> wrote:
>
> Hmm... My problem with our extended data-table is that it is much
> toooo overweight already. Couldn't we work with an extra component
> here, which has a for-attribute referencing a dataTable-component, and
> displays the button and on click the excel data for the dataTable?
>
> regards,
>
> Martin
>
> On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> > Hi,
> >
> > I've created a new feature for the datatable that allows exporting
> presented
> > data to the excel format.
> >
> > Simply an excel button is placed on the datatable header and clicking on
> it
> > makes an ajax request, a popup is displayed and excel file is presented.
> >
> > Following are the two screenshots;
> >
> > http://img206.imageshack.us/my.php?image=table17gs.jpg
> >  http://img80.imageshack.us/img80/3568/table7xm.jpg
> >
> > This was a requirement needed in my last project, I think it would also
> be
> > useful if I integrate this for our extended datatable with an attribute.
> >
> > What do you think?
> >
> > Cagatay
> >
>
>
> --
>
> http://www.irian.at
>
> Your JSF powerhouse -
> JSF Consulting, Development and
> Courses in English and German
>
> Professional Support for Apache MyFaces
>

Re: Excel Export for Extended Datatable

Posted by Martin Marinschek <ma...@gmail.com>.

Hmm... My problem with our extended data-table is that it is much
toooo overweight already. Couldn't we work with an extra component
here, which has a for-attribute referencing a dataTable-component, and
displays the button and on click the excel data for the dataTable?

regards,

Martin

On 8/23/06, Cagatay Civici <ca...@gmail.com> wrote:
> Hi,
>
> I've created a new feature for the datatable that allows exporting presented
> data to the excel format.
>
> Simply an excel button is placed on the datatable header and clicking on it
> makes an ajax request, a popup is displayed and excel file is presented.
>
> Following are the two screenshots;
>
> http://img206.imageshack.us/my.php?image=table17gs.jpg
>  http://img80.imageshack.us/img80/3568/table7xm.jpg
>
> This was a requirement needed in my last project, I think it would also be
> useful if I integrate this for our extended datatable with an attribute.
>
> What do you think?
>
> Cagatay
>


-- 

http://www.irian.at

Your JSF powerhouse -
JSF Consulting, Development and
Courses in English and German

Professional Support for Apache MyFaces