Exporting views as excel

I was browsing the eknori.de blog about domino when I found some interesting code about an
Excel Report Class:

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)

It was an example on how to use the Excel Report Class by Christian Gorni.

I guess all developers comes across this problem now and then, the last time I was forced to do an excel report I was lucky that the user was running Microsoft Office 2003 so I simply had to print some XML code to get a decent excel report. Unfortunately not all offices uses the latest desktop software so this tool is really helpful.

Leave a comment

Your comment