At the marvelous Engage conference I had the honor to speak about "How to get my app on mobile?". Between the obvious choices of having a … more
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:
Print |Content-Disposition: Attachment; filename="exportToExcel.xls"|
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>|
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.
Sie haben Fragen zu diesem Artikel? Kontaktieren Sie uns gerne: email@example.com
"Drive your dreams" - is the motto of this year's international Engange conference, which will take place in Brussels for three days ... more
9,6% market share and 18% market growth for IBM in the AI sector in 2017 – that is the impressive result of a study … more