Christian Gorni today released his Excel Report Class on OpenNTF.
Just use the database. It includes the complete ExcelReport class and two agent examples. As a teaser, the following is all you need to export a view to excel in LotusScript:
Set view = ws.CurrentView.View Set report = New ExcelReport(excelfilepath, False) Call report.exportNotesView(view, Sheet, OffsetX, OffsetY, isWithHeader, includeIcons, includeColors, includeHidden) Call report.setVisibility(True)
Of course the obvious (getting and setting cells, saving, …) is also included. Be careful, because error handling is not yet implemented.
Here are the implemented methods:
Sub new (xlFilename As String, isVisible As Boolean) Sub delete () Function save () Function saveAs (filename as String) Function quit () Function setCell ( Sheet As Variant , row As Integer , column As Variant , value As String ) Function getCell ( Sheet As Variant , row As Integer , column As Variant ) As String Function setVisibility (isVisible As Boolean) Function setCellColor ( Sheet As Variant , row As Integer , column As Variant, innercolor As Variant ) Function setCellFont ( Sheet As Variant , row As Integer , column As Variant, style As Variant, size As Variant, color As Variant ) Function getVersion () As String Function exportNotesView (view As NotesView, Sheet As Variant, OffsetRow As Integer, OffsetCol As Integer, isWithHeader as Boolean, includeIcons As Boolean, includeColors As Boolean, includeHidden As Boolean)