I want to export data from Microsoft Excel into a Lotus Notes application. What is the limitation on the format...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
of the Microsoft Excel spreadsheet design (layout), and where can I find more information or tips about doing this?
I don't know what you mean by the limitation on format of Microsoft Excel layout. You can check out the various Microsoft product and support sites for further information.
If your spreadsheet has rows of data that will be imported into individual Lotus Notes documents, you can import the file from the Lotus Notes menu.
There is a SearchDomino.com tip, Export any view to Excel that shows how to create a Microsoft Excel file from a view and populate the rows of the spreadsheet. This covers a lot of what you may want to do. Of course, you'll need to adapt the code to your purpose.
In addition, there is a SearchDomino.com Featured Topic, LotusScript and Excel that has links to many other examples.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Lotus Notes Domino Application Development
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response.continue reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead.continue reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.