Background

Anyone use that horrendous @Command([FileExport]…) thing? Worse still, does anyone recall how Lotus changed some of its parameters in the move from R4.x to R5.x! Heinous! (I did a rant about that some time ago).

Well, I'm not here to talk about that… it's of limited use in the real world anyway; most users have a more pressing need to export view data to MS Excel, rather than 1-2-3 in this day and age. Sure, we could all rant on about M$ now, but let's just face facts.

Anyway, please find the code attached. It's a basic implementation — feed the routine three arrays, and you're done. The arrays should all have the same number of elements, and represent:

1. the columns in your new worksheet
2. the Notes fields that these should map to, and
3. and the width of your columns

You can spruce this code up to process multivalue fields, define additional worksheet properties, etc., etc. This is just a starter, and I hope it helps someone out there. The "Further reading" link is also useful in terms of expanding the code for your own purposes.

Example call

Oh yes, here's what a typical call would look like (here I've coded an agent which exports three bits of info from selected documents in one's mail file):

	Dim session As New NotesSession
	Dim db As NotesDatabase
	Dim strCols(2) As String
	Dim strFlds(2) As String
	Dim intCells(2) As Integer
	Dim dc As NotesDocumentCollection
	
	Set db = session.CurrentDatabase
	Set dc = db.UnprocessedDocuments
	
	strCols(0) = "From"
	strCols(1) = "When"
	strCols(2) = "Subject"
	
	strFlds(0) = "From"
	strFlds(1) = "PostedDate"
	strFlds(2) = "Subject"
	
	intCells(0) = 18
	intCells(1) = 18
	intCells(2) = 18
	
	Call exportToExcel(dc, strCols(), strFlds(), intCells())

Filed underquick tips, lotusscript, export, views, ole