Problem solve Get help with specific problems with your technologies, process and projects.

Can I create and copy Microsoft Excel spreadsheets with LotusScript?

Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony.

How do I create an Excel spreadsheet using LotusScript? I also want to copy one Excel spreadsheet to another using LotusScript.
Microsoft Excel is a proprietary Microsoft format and the APIs that allow you to create it belong to Microsoft. If you're running on a system that has Excel installed, you can use Object Linking and Embedding (OLE) automation to create and populate the spreadsheet. The heavy lifting is done by code that is part of Excel. There have been many articles written about how to use OLE automation with Excel from LotusScript, which you can easily find if you search the Internet for "createobject excel lotusscript".

Starting with Lotus Notes version 8.0.1, you can use the same techniques to manipulate Lotus Symphony spreadsheets. This code has the advantage of being part of the Notes client, so you don't have to install Office. However, it is also Windows-only.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchDomino.com:

  • Tip: How to import data from Excel to a Lotus Notes form with LotusScript
  • Tip: How to export Lotus Notes views to a Microsoft Excel database
  • Tip: Create file system labels for Microsoft Excel and Word mail merges
  • Dig Deeper on LotusScript



    • 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 ...