I am trying to create a program that can run from a Web browser by using Lotus Script to create a report with an Excel spreadsheet. The data is contained in a Domino database. I have created a Notes environment many times in the past. However, is there anyway I can do this with a Web browser?
If I understand correctly, yes. You could have the browser run an agent from the WebQuerySave event of a form, or directly from a URL (i.e.www.libertastechnologies.com/test.nsf/test?openagent ) that would use COM to create an Excel spreadsheet on the server and then write data into. I have actually done this with both Word and PowerPoint. Keep in mind that you'll need to have Excel installed on the server so that the appropriate objects can be created in your code and that server will need to be able to write the excel files into a folder on the server.
Dig Deeper on Domino Resources - Part 3
Related Q&A from Dave Hatter
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.