Create a lotusscript agent that is called with the view and selected documents.
The secret to export to excel is this line:
Print "Content-Type:application/vnd.ms-excel"
'Then you need to start to define the columns and data:
Print "<HTML><HEAD><TITLE>Excel from Web</TITLE></HEAD><BODY><TABLE>"
'Optionally put in some CSS code to format the headings nice:
print|<style>|
print|.style0 {|
print| text-align:general;|
print| vertical-align:bottom;|
print| border-bottom: 1px solid black;|
print| font-weight: bold;|
print| color: #000000;|
print| background: #A0A0A0;|
print|}|
print|.style1 {|
print| border-bottom: 1px dotted gray;|
print| border-left: 1px dotted gray;|
print| border-right: 1px dotted gray;|
print|}|
print|</style>|
'Put the headings in
print |<TR>|
print |<TD class='style0'>Heading 1</TD>|
print |<TD class='style0'>Heading 2</TD>|
print |</TR>|
'Then put in your data lines ' maybe using a loop
print |<TR>|
print |<TD class='style1'>Row 1 Col1</TD>|
print |<TD class='style1'>Row 1 Col2</TD>|
print |</TR>|
print |<TR>|
print |<TD class='style1'>Row 2 Col1</TD>|
print |<TD class='style1'>Row 2 Col2</TD>|
print |</TR>|
'Then finish off
Print "</TABLE></BODY></HTML>"
Nice an easy.
Of course this might work with Open Office as well.
If you have the vnd description you can use that to change it to Open Office.
For people wothout excel, you can output the data as Content-type: text/csv
Another option is to end the agent's url with the text file type eg: http://server/db.nsf/agent?open&.csv or .xls
I do this with RSS and it works well. &.xml