At times you want to export documents from a Domino Web application in order to work with the data in a spreadsheet like Microsoft Excel, to prepare, process and visualize the information.

A simple, but flexible way is to write an LotusScript agent in the Web app, which "prints" a HTML table:

Sub Initialize()
Print |Content-Type:application/vnd.ms-excel|
Print |Content-Disposition: Attachment; filename="exportToExcel.xls"|
Print ||
Print |<table>|
Print |<tr><th>Tabelle</th><th>1. Spalte</th><th>2. Spalte</th><th>3. Spalte</th></tr>|
Print |<tr><td>1. Zeile</td><td>1</td><td> 2</td><td> 3</td></tr>|
Print |<tr><td>2. Zeile</td><td>2</td><td> 4</td><td> 7</td></tr>|
Print |<tr><td>3. Zeile</td><td>3</td><td> 7</td><td>14</td></tr>|
Print |<tr><td>4. Zeile</td><td>4</td><td>11</td><td>25</td></tr>|
Print |</table>|
End Sub

The "trick" is to start with the Content-Type "application/vnd.ms-excel".

Instead of just printingt static data (like in the example), the agent would calculate the table using a view or search and iterating through the documents.