I developed a Lotusscript class that makes writing to an Excel file very easy.
It uses an Excel file as model. All the formating, presentation and
calculations are defined in the Excel model.
In the model file, target areas for Notes data are defined using cell naming.
Giving to a target cell the same name as a Notes document item is enough to
ensure the right filling.
You can find more details, and a (free) demo database at the following address:
http://seusoft.com/en/ExcelReport01.html
I developed a Lotusscript class that makes writing to an Excel file very easy. It uses an Excel file as model. All the formating, presentation and calculations are defined in the Excel model. In the model file, target areas for Notes data are defined using cell naming. Giving to a target cell the same name as a Notes document item is enough to ensure the right filling. You can find more details, and a (free) demo database at the following address: http://seusoft.com/en/ExcelReport01.html