Ask the Expert

Resources for exporting Lotus Notes data to Lotus 1-2-3

I need information or an example about exporting Lotus Notes data to Lotus 1-2-3. Thank you.
You didn't really say anything about the context in which you need to do this export, but I'm assuming that you want to do this in a program, as opposed to just using the menu command File/Export from a view.

The 1-2-3 Export functionality in Notes is not directly available from LotusScript, but in macro language you can use @Command([FileExport]; "1-2-3"; filename) to export information from the current view. The user will be prompted whether to export all documents or only selected documents and whether to include view titles.

If this is not good enough, you can use LotusScript to create an export file. There are two ways to do this (assuming you do not want to have to learn the 1-2-3 file format and write your own code to produce the binary file).

First, if your code is running on a platform that supports OLE automation and has 1-2-3 installed, you can use OLE automation to create a new spreadsheet, set values and formatting for its cells, and save the resulting 123 file. There are numerous examples in the LDD Notes/Domino 4 and 5 forum and the SmartSuite forum that do exactly that.

Alternately, if OLE automation is not an option, you can create a CSV file. This is just text, with any text values enclosed in double quotes (if there are double quotes in the text, change these to double-double quotes (e.g., the string Robert "Big Bob" Malloy becomes "Robert ""Big Bob"" Malloy" in the CSV file). Number and date values are not enclosed in quotes. 1-2-3 can perfectly well understand this file type, though it doesn't allow you to format the cells.

This was first published in March 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: