Export Domino View Data to Excel with an XPages Custom Control

Julian Buss, YouAtNotes


May, 2010

Discover how to wrap code that exports a Domino view to Excel in a small package you can use anywhere in any XPages application. Each of the development techniques in the solution — including a shortcut that eliminates the need to write data in native XLS format — is explained in full and then demonstrated in a sample application you can download.

Export Domino View Data to Excel with an XPages Custom Control
Julian Buss, YouAtNotes
May, 2010
Users just love getting their data in Excel spreadsheets, so one very frequent question for the Domino developer is, “How can I code a Notes and Domino view export to Excel?” There’s extensive information available on how to do this using LotusScript, but it’s not that easy to answer the question if you’re building Web applications with Domino XPages.
The biggest hurdle in exporting Domino data to Excel is the Excel-specific XLS format. It is proprietary and closed and, as a result, writing a file in this format requires a huge effort. But there’s a shortcut I’ll show you that makes it easy and quick. Best of all, the solution is reusable, thanks to the Custom Controls feature of XPages.

Would you like to see the full version of this article?

If you are an electronic license holder to THE VIEW, please log in to view this article.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in THE VIEW Online Knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8813 to speak directly with a subscription and licensing specialist about customized access for you and your team.