Case360 - Hyperlink on result page for excel sheet generation

Alan Hitchings

By JAGDISH MASSAND

 

I noticed in Case360 -> Queries we can create a query which can directly generate an excel sheet for search results. I would want to know if there is a way to have a query which will display results on webpage and if we can have an option/button on the results page to export the entire rsults into an excel sheet. Currently we are writing independant servlets to perform this functionality which takes lot of development effort.

Regards,

Jaggy.

Alan Hitchings

By Scott Ghidiu

 

Hi Jaggy,

I think you would have to make your own button in the query output JSP, which calls the query servlet for a 2nd copy of the query, which uses a different JSP to give you the excel sheet output.  If you require more info on this, please open a support case.  Thanks!

 

Alan Hitchings

By mfarina

 

Hi,

i've already developed this feature. It is possible to convert a query result in a excel sheet or multiple query in several excel sheets.

There are several ways to get that.

you can retrieve query results in xml and so to convert in excel o try to read xml directly from excel otherwise you can populate excel worksheet from java.

feel free to contact me if you want more details.