CODEWITHSUNDEEP
exceluser-interfacelotus-notes
user2964063
user2964063

Reputation: 1

I am a Lotus Notes database user and want to export some views to Excel

When I do this thou not everything is getting exported - some of the columns are marked with a green check mark and I want these marks to be exported as well. But this seems not possible - I select the table with Ctrl+A, then right click, copy as table and in Excel Ctrl+V.

This gives me only the names of the columns in the table but not the green check mark. Is there any way to do this such that the marks are visible in Excel?

The version I work with is Lotus Notes Standard 8.

Upvotes: 0

Views: 2226

Answers (1)

Karl-Henry Martinsson
Karl-Henry Martinsson

Reputation: 2795

You could write a Lotusscript agent. It is actually not very hard at all.

And to make it even easier, you can use a class I wrote a while back, it will do all the work for you. You can find the class on my blog at http://blog.texasswede.com/export-notes-view-to-excel-with-multi-value-fields/

Here is how you use my class:

Dim csv As CSVData
Dim outfile As String

Set csv = New CSVData("DominoServer/YourDomain", "names.nsf", "People\By Last Name")
'*** Create CSV file from view
outfile = "c:\ExcelExportTest.csv"
Open outfile For Output As #1
ForAll row In csv.CSVArray()
    Print #1, row
End ForAll
Close #1

Easy, huh?

Upvotes: 1

Related Questions