Excel 2007 XLL SDK Unicode String Support Update

The Microsoft Excel 2007 XLL SDK introduced a new data structure, the XLOPER12, which allows your addin to obtain Unicode strings in XLL function calls.  However, there were a couple of limitations with the implemention of the SDK which prevented your XLL from taking full advantage of this new capability. Specifically, while Excel 12 would allow strings in…

0

Excel OLE Embedding Errors if you have Managed Add-In Sinking Application Events in Excel

Summary If you build a managed component that loads into Excel’s process space, and the managed code uses the PIA (or a custom IA using event delegates)  to sink events on the Application object, that Excel instance may encounter problems when used for OLE embedding.  The problems include: Being unable to update object if it…

1

Excel 2007 does not return shape data using XLL xlfGetDocument command

Summary Microsoft Excel XLL add-ins using the xlfGetDocument command with the command type 42 to return a matrix of shapes (objects, images, controls) on the active sheet may encounter problems in Excel 2007, because the command fails to return any such information to the add-in.   The caller receives no error, but gets back an empty XLOPER, as if…

1

Excel 2007 Extension Warning On Opening Excel Workbook from a Web Site

Summary Web sites that use the “application/x-msexcel” or “application/vnd.ms-excel” MIME type to open web page content inside of Microsoft Excel may encounter the following warning prompt when the file attempts to open in Excel 2007: “The file you are trying to open, ‘[filename]’, is in a different format than specified by the file extension. Verify…

4