Saturday 10th, February 2007
Portlet Factory - exporting data to Excel02/10/2007 Portlet Factory
I was recently working on exporting data from a Websphere Portlet Factory application to Excel. Portlet factory has an "Excel Export" builder that makes exporting data from a service provider easy.
The 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
The 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
This page has been accessed 609 times.
?OpenAgent&0346EDCDBD3AC93F8525728500570682)
Comments :
No comments.
