Notes/Domino XPages Development Forum - Export to Excel from data table

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

~Jennifer Ekjipymarettu

Oct 15, 2012, 7:51 AM

25 Posts

Export to Excel from data table

Category: Server Side JavaScript
Platform: Windows
Release: 8.5.2
Role:
Tags:
Replies: 2

Hi,

I have an xPage with data table. I have implemented search and filtration functionality on same xPage. Collection of data from data table changes base on search and filter criteria. Now I want to export the data from data table (may be search,filter,sorted data) to excel so how do i do that? Can any one plz help me. Thanks in advance.

~Cheryl Elhipigenlen

Oct 15, 2012, 1:44 PM

366 Posts

Re: Export to Excel from data table

I find it is easiest to duplicate the sorting/filtering programmatically to produce the desired result set and then use that data to create an Excel spreadsheet via the Apache POI library.

~Isaac Fezboosiakoi

Oct 17, 2012, 5:42 PM

586 Posts

Re: Export to Excel from data table

I agree with Paul.

Basically have a button to export the data. Then send them to a page that's an XAgent - re-get your data from whatever criteria and export from there. I've not used Apache POI yet but there are examples of exporting to Excel the html way on index.notesin9.com as well as cheatsheet.notesin9.com. The cheatsheet site should have a downloadable nsf with an export example.

Dave