Exporting data from Microsoft Excel to Lotus Notes

SearchDomino.com expert Brian Mahoney offers advice and on manipulating Microsoft Excel data for Lotus Notes applications and provides links to additional tips and resources.

I want to export data from Microsoft Excel into a Lotus Notes application. What is the limitation on the format...

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...