This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Vanessa Asalumarobu
Jul 16, 2015, 5:18 PM
6 Posts

Unable to create Excel Spreadsheet

  • Category: Notes Client
  • Platform: Apple Mac OS
  • Release: 9.0.1
  • Role: Developer
  • Tags: CreateObject
  • Replies: 2

I have an application running on Windows, and now some of my users are starting to use MACs.  The export to excel agent works fine on Windows, but fails on the very first reference to Excel

     Set xlApp = CreateObject("Excel.Application")

The error message is Error  180: Operation not supported on this platform.

Microsoft Office 2011 Version 14.5.3 is installed on the Mac Pro.

The CreateObject function (LotusScript Language) help says: Creates an OLE Automation object of the specified class. Note: CreateObject is not supported under OS/2 or UNIX.

 

No mention of an exception on Macintosh.

Any ideas?

~Fritz Ekfoobergflar
Jul 16, 2015, 6:03 PM
202 Posts
Macintosh doesn't have OLE automation
Probably IBM never updated that documentation, as the Mac version didn't exist at the time it was written.
~Anita Minasterings
Jul 17, 2015, 1:21 PM
90 Posts
what Carl said but...
Excel files are XML files now. You can create XML files in your agent using LotusScript or Java. Or, if using Java, you can Apache POI to help in the creation of the Excel file. We have examples of this in our Java 2 for XPages course at www.tlcc.com. What we do there would also work in a regular Notes Java agent too or you could just point them to a url that runs an XPage that generated the Excel file.

So, to support the Macs you would need a new approach.

Howard

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal