Portlet Factory - exporting data to Excel02/10/2007The twist here is that the user also wants to have the data match exactly with the various sort options selected from a view. These were based on the column headings they have clicked on. I also provide the user with a query interface to allow them to drill down on the data. This needed to be included also. So this was not going to be easy....
I immediatley assumed I would need to capture the clicked columns some how and sort the filtered data in java or pass this info to an SQL query to perform. I was pleasantly surprised to find that if I used the same result set that the view was presenting to the user, that it was physically sorted according to the columns they have clicked on. I also filter that result set using the drill down technique I built. So the Excel export matched the data in view exactly. It could not have been any easier.
John
Here's a screen shot of the Excel Export Builder:
Technorati: Websphere Portlet Factory
1. Ramkrishna Kumar03/26/2010 07:47:08 AM
Hi John,
I read the article regarding Portlet Factory - exporting to excel. I am new to Portlet Factory. I am facing a problem while exporting the user view data into excel file.
My web page has a table and a chart, the table has nearly 300 columns.
I am hiding the columns which do not have data for any row, using javascript.
This page is created using Summary and drilldown builder, so i checked the excel check box from the builder hence it has the excel button on the page.
The excel export works fine but the only problem is that the exported excel contains all the 300 columns.Even those columns which i got hidden using javascript are also exported into the excel.
Please suggest how the hidden columns could be excluded from the exported excel.
Please help.
2. Ramkrishna Kumar03/26/2010 07:54:23 AM
Hi John,<br>I read the article regarding Portlet Factory - exporting to excel. I am new to Portlet Factory. I am facing a problem while exporting the user view data into excel file.<br>My web page has a table and a chart, the table has nearly 300 columns. <br><b>I am hiding the columns which do not have data for any row, using javascript.</b> <br>This page is created using Summary and drilldown builder, so i checked the excel check box from the builder hence it has the excel button on the page.<br>The excel export works fine but the only problem is that the exported excel contains all the 300 columns.Even those columns which i got hidden using javascript are also exported into the excel.<br><b>Please suggest how the hidden columns could be excluded from the exported excel</b>.<br>Please help.
