Thanx Sean for ur help.
I tried using POI for ecel stuff but thats not the way i want it.
The thing is that home page of my application displays some rows of data from database using <x:datatable>
I want to put a link at the bottom of the home page (See In Excel) which will open a pop up window and display the table values
in excel sheet. I should also be able to save the opened excel sheet.
Is there any way to directly use the data from the datatable and show it using Excel?
Cld anyone provide sample code for it?
Thanx in advance Sunil
----- Original Message ----- From: "Sean Schofield" <[EMAIL PROTECTED]>
To: "MyFaces Discussion" <[email protected]>
Sent: Monday, May 02, 2005 10:09 PM
Subject: Re: Regarding datatable
AFAIK there are no MyFaces components that will do this for you. You could probably modify one of the existing ones to do some of the Excel stuff you are talking about. Check here: http://jakarta.apache.org/poi/ for a good open source library for Excel.
HTH, sean
On 5/2/05, Sunil Tiwari <[EMAIL PROTECTED]> wrote:
Hi,
How to display the sum of all columns (with integer values) in the last
column of the datatable from front end only.
Moreover, it should display the column total for every column at the bottom
of the table.
And all the other functionalities of the table shd be still supported like
pagination and scrollability.
Like a table is displaying 100 records and i display 10/20/40 records per
page. It shd then display the column totals for every page
for 10/20/40 records.
Does anyone knows then how to display the details of the datatable in an excel sheet from within the MyFaces application.
Thanx in advance
Sunil
