May 19, 2006


Using data in a MS Excel sheet in Lotus Notes.


Filed under: Uncategorized, General, Lotus Notes, SME Info — Bushan @ 5:25 am

Lotus Notes has a feature where information in Microsoft Excel can be used in its documents, forms and views.To transfer the data from an Excel sheet to the Notes document,we can create an embedded object in the Notes document or form.

What is an embedded object?

Data available in one file(source) can be transfered to another file(Destination) by inserting them.This process is called Embedding.The data transfered is called the object or the Embedded Object.
Whenever there is a change in the object it is automatically updated in the Notes Document.Alternatively,the data from a Microsoft Excel work book can be imported into the Notes Document or Forms.When you import the data to Lotus Notes, the data alone is tranferred and there is no link maintained between the Excel workbook and Lotus Notes.So, even if there is any change in the source document, no change happens in the Notes document or form to whichthe data was tranferred.

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.