Export to excel agent on web

HCL Domino Domino Forum
1

Hi there!

I have to create an export to excel agent that will work on the web.

An excel file has to be created and the user has to be prompted to download it.

I would just like some advice on the procedure to follow please.

I was thinking of creating the file, putting it inside a doc and loading it using the ?OpenElement url command.

Is there a simpler way of doing it?

My second question is that I use OpenOffice 2.0.2 and I cannot create excel files using notes agents.

Does anybody have a code example please.

2

Subject: export to excel agent on web

Thank you kenneth,

I know MS Excel has to be installed on the server and I already have an agent that creates the excel file.

I want the user to select the view he wants to export and propose him to download the file created to his pc.

I create the file on the server, put it in a doc and redirect the user to the url to download the file using the $file/…?OpenElement URL command…I can already do this…

The problem is that there will be lots of excel files created on the server.

So I was wondering whether I could create an excel file and put it in a doc without saving it to the server’s disk…or whether there is a way to delete the file once it is downloaded.

Or maybe if there is a way to make a scheduled agent delete excel files that are not used anymore.

3

Subject: RE: export to excel agent on web

Well, you already seem to have most things sorted out then.

By storing the file(s) as attachments in documents, there is no need at all to keep them as files anywhere.

As for deleting, if an excel file (attached to a document) is no longer needed, you can always delete the document.

I may have mis-understood the whole issue here.

Please excuse me if that is the case.

4

Subject: RE: export to excel agent on web

thanks a lot Kenneth…but it turns out that all I was needing was the ‘Kill’ command in Lotusscript to delete the excel file…It all works now

5

Subject: export to excel agent on web

If you want to dynamically create an Excel spreadsheet ‘properly’ you would have to have MS Office (or at least MS Excel) installed on the server.

There are some ‘kits’ out there that can help you create files with all the correct header-info and stuff so that a file in that manner is really considered to be a proper Excel-file. I have never really tried any of those fetures myself, so can’t really say how well they perform.

If you don’t have the need to create Excel files dynamically on the server, you could always have an administrator person create the file on a PC and then just attach the file to a document.