Notes/Domino XPages Development Forum - Word processor and spreadsheet integration with XPages

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

~Howard Deskiveroopsi

Dec 17, 2011, 5:08 PM

13 Posts

Word processor and spreadsheet integration with XPages

Category: Other
Platform: All
Release: 8.5.3
Role: Developer
Tags:
Replies: 2

In the Notes client I have gotten used to working with document attachments like Writer/Word/Calc/Excel. In the past I have programmed integration with these types of attachments, like reading values from the attachment and writing values to the attachment.

In a running project I have to come up with a way to get a similar functionality using XPages through a browser. I.e:

use of attachment templates
enter values into the attachments from the database
reading values from some of the attachments and storing them in the database.
word processing formatting capabilities
spreadsheet calculation capabilities and flexibility
available through programming

I would very much appreciate if anyone could point me in some direction(s) here.

Johnny

~Rex Umreman

Dec 17, 2011, 6:43 PM

272 Posts

Re: Word processor and spreadsheet integration with XPages

Hi Johnny,

do you know the Apache POI Project? Perhaps this will fit your requirements.

Sven

http://blog.hasselba.ch

~Howard Deskiveroopsi

Dec 18, 2011, 11:46 AM

13 Posts

Re: Word processor and spreadsheet integration with XPages

Thank you. I wasn't aware of it. It seems to do the same job as UNO for Open/Libre-office, which I have used with Lotusscript in the notes-client.

The next question then is XPage related - Any idea how to

get a handle to the already attached file in a notes-document
fire up e.g. Word, do the POI-things and then let the user do some editing
after the user have finished, and saved his document - update the attachment in the notes-document before saving it

Johnny