This method is very similar to the CSV method. So make a habit to format any numbers without commas.
Dates and numbers don’t need quotes around them, as long as they don’t contain commas. This helps on the receiving side, but is optional. The first row is the header, with the field names listed. You need to build a string containing a complete line, as the Print statement adds a line break to the end automatically.Ī CSV file could look like this: FirstName,LastName,Department,StartYear Use regular Lotusscript file operations and write the values to the file, encased in double quotes and separated by a comma. The easiest way to get data from Notes to Excel (or any other spreadsheet program) is to simply save the data as comma-separated values (CSV).
HOW TO TRANSFER EMAIL FROM LOTUS NOTES 10 CODE
That just makes things more complicated, and if you run the code in a server agent, Microsoft Office have to be installed on the server itself. You don’t need to automate Excel, something the programmers posting in the forums seem to frequently do. IamLUG 2009 – Integration and Coexistanceīut if you just need to export raw data to Excel, there are a couple easy ways to do that. My guess is that some manager/executive want to get the data to manipulate and analyze it in Excel, which they know better, and where reporting can be done easier.įirst of all, for anyone that want to do real integration with Excel (or Word, or any other office program), I would suggest to look at the presentations given by John Head at Lotusphere and other conferences in the past: One very common is to export data from Notes/Domino to Excel. While reading the developerWorks forums, I have noted that some tasks seem to be common, and users often have issues with it.