Welcome to Notes411.com
FAQ Home :
How do I get data from Lotus Notes or Domino to Excel.
How do I get data from Lotus Notes or Domino to Excel.
Answer
By using OLE Automation, we can access the MS Excel Application Object within LotusScript. Scripting in Lotus Notes is very similar to VB and by looking at other peoples VB sample code on the internet you can get good information on how to automate Excel.
We have attached two of our articles that show how to export data form Excel
How to export to Microsoft Excel. Similar to CSV export,but to .xls file. Export Notes view to file. Export agent demo.
http://www.notes411.com/dominosource/resources.nsf/0/5AD44DF19D488BF880257139002F1768!opendocument
How to export categorised views with multivalues to Excel. Lotus Notes Export to Excel using an agent.
http://www.notes411.com/dominosource/tips.nsf/0/CF19DA783B4D4515802571930080F144!opendocument
Attachments
-none-
Applies to versions
FAQ Provided By
SC Robinson
Credit
Forum Latest Entries
29/07/2010
Lotus Notes Forum - AppendDocLink to Doc in Db-A to from a Doc in Db-B
(Rus)
28/07/2010
Lotus Notes Forum - Get Document from another db and appenddoc link to a field in source
(Rus)
24/06/2010
Lotus Notes Forum - Lotus Notes 6.5 Programming Certification Test
(Charles)
21/06/2010
Lotus Notes Forum - Consult
(Rogers )
09/06/2010
Lotus Notes Forum - #error : Must specify type of OS ("DOS", "OS2", etc) on C command line
(Abhi)
31/05/2010
Lotus Notes Forum - Note mail error
(Anonymous)
28/05/2010
Lotus Notes Forum - lotus notes 8 calendars & email setup...
(Dermick Vaughn)
19/05/2010
Lotus Notes Forum - Stop sending delivery and read receipts
(Simon)
19/05/2010
Lotus Notes Forum - Folder Restore Tool v2.5 is released, try for ten databases for free
(Kim van den Berg)
19/05/2010
Lotus Notes Forum - Try our Archive Solution for free for ten databases (mail/applications/quickr places)
(Kim van den Berg)
14/05/2010
Lotus Notes Forum - Adobe fillable form submit Email button not working with lotus
(Anthony )
12/05/2010
Lotus Notes Forum - Recipients on archived mails differ from regular mail
(Borja)
03/05/2010
Lotus Notes Forum - Name change only partially works
(Anonymous)
02/05/2010
Lotus Notes Forum - How to edit value in MASTER from, and backupdate MAIN form??
(Julee)
22/04/2010
Lotus Notes Forum - Note 8 Alarms Not Working
(Tony D)
07/04/2010
Lotus Notes Forum - Lotus Notes Agent to send an e-mail every month
(Lorant)
31/03/2010
Lotus Notes Forum - Lotus Notes C++, LNText Item, Unicode
(Matt)
19/03/2010
Lotus Notes Forum - Searching for a date in a document collection
(Kris Mitchell)
16/03/2010
Lotus Notes Forum - Lotus CAPI --> CSharp
(HW)
12/03/2010
Lotus Notes Forum - Notes IMAP connection
(Charl)
Latest Tips & Tricks
10/07/2009
Terminal Services Tips & Tricks - How to kill terminal server sessions. Utilities for terminal services: qwinsta and rwinsta
(Steven Charles Robinson)
10/07/2009
.NET Tips & Tricks - The type or namespace name
could not be found (are you missing a using directive or an assembly reference?)
(SCRobinson)
10/07/2009
Terminate Lotus Notes Processes, Error Tips & Tricks - Lotus Notes: An Error Was Encountered While Opening A Window
(Steven Charles Robinson)
26/04/2007
LotusScript Mail, SMTP, Spam, Junkmail Tips & Tricks - How to drag and drop spam into junk mail filter using LotusScript
(Steven Charles Robinson)
31/10/2006
Terminate Lotus Notes Processes, Error Tips & Tricks - Lotus Notes: An Error Was Encountered While Opening A Window
(Steven Charles Robinson)
23/10/2006
Errors, SMTP, Internet Sites, Configuration, Administration, Domino 7 Tips & Tricks - Domino authentication is not enabled in the smtp internet site document
(Steven Charles Robinson)
20/10/2006
Articles Tips & Tricks - Have you see our recent arcticle in "The View": Proven techniques for abstracting UI from data using XML, XSL and Domino.
(Steven Charles Robinson)
26/09/2006
.NET Tips & Tricks - If your looking for .NET tips visit http://www.codedotnet.net
(S C Robinson)
25/09/2006
Using Lotus Notes Tips & Tricks - Save the Window state of a Lotus Notes client on shutdown.
(Steven Charles Robinson)
22/09/2006
NET, Culture, Globalization Tips & Tricks - How to find out the current culture in a .NET application.
(Steve C Robinson)
© 2003 notes411.com. All rights reserved.
Disclaimer
. site designed & developed by
appsworks.com
Lotus Notes is a registered trademark of IBM. This site is not affiliated with
IBM
or
Lotus
.
Welcome to Notes411.com
News
Google Box
Sponsor
Best in the Industry
Menu
What's New
How to Advertise
Hit Statistics
About Us
Contact
Contact Us
Disclaimer
Registered
Login
Register
Add a Resource
Tips & Tricks
Forum
Resources
DominoFAQ
Home
Notes411 Search