XLL+ 6.3 for Visual Studio .NET - 30-day trial

XLL+ 6.3.7 is a maintenance release, which replaces all earlier versions XLL+ 6. You should uninstall any earlier versions of XLL+ 6, including XLL+ 6.3.4 (and the patch release, XLL+ 6.3.5) before you can install this release. It contains the following fixes and enhancements:

E00229 - Non-RTD handle mechanisms

The non-RTD handle mechanisms, StringHandle and StringPtrHandle, have been enhanced to support smart pointers (including boost::shared_ptr) and also custom handle formats.

E00230 - CXllApp::GetListSeparator, CXllApp::GetRowPrefix, CXllApp::GetColumnPrefix

Three new CXllApp methods can be used to report international settings during worksheet functions (when CXllApp::GetInternational may not be called).

E00231 - CXllApp::GetXllFileName, CXllApp::GetXllFileNameOnly

Two new helper methods provide parts of the current XLL's path.

F00132 - .NET Reflection - Null values in string arrays are now converted to empty strings

For wrapped functions which return string arrays, any contained null values are now converted to empty strings. Previously an exception was thrown.

F00134 - Help Generator: omitting default text for optional arguments

Argument help for optional arguments was still being generated when the Position attribute was set to 'Replace'. This behavior has been fixed, and the default value description is now omitted.

F00135 - CXlFuncs Lookup and Reference Functions

A number of CXlFuncs methods take parameters that represent a row or column index, but are represented only as small integer types. New or changed versions of each of these methods have been provided so that the row or column index is a large integer type, as required by Excel 2007 and above. The following are affected: CXlFuncs::Address, CXlFuncs::HLookup, CXlFuncs::Index, CXlFuncs::Match, CXlFuncs::Offset, CXlFuncs::VLookup

F00136 - CXlMacros Range Functions

A number of CXlMacros methods take parameters that represent a row or column index, but are represented only as small integer types. New or changed versions of each of these methods have been provided so that the row or column index is a large integer type, as required by Excel 2007 and above. The following are affected: CXlMacros::HLine, CXlMacros::HPage, CXlMacros::VLine, CXlMacros::VPage.

F00137 - RTD handles fail in Excel 2002 using languages other than English

A bug in Excel 2002 meant that RTD handles usually returned the error "#ERROR: Excel API call RTD failed with error code 32", when working in some languages other than English. A work-around has been applied, so that this behavior has been fixed.

F00144 - Async functions with string arguments fail

If multiple instances exist of an asynchronous function with one or more string arguments, then the string argument passed to the function is arbitrary. This behavior has been fixed.

XLL+ Release 6.3 was a major release and replaced all versions and patches of XLL+ 6.0 and XLL+ 6.2. It contains many new features, including:

Hidden regions

Almost all of the generated code is now surrounded by #pragma region blocks. This means that almost all of the implementation code for each add-in can be hidden, and you need only see the code that is interesting - the function signature and your own code.

XLL Wrapper Libraries

The Xll Wrapper toolkit contains tools, a runtime library, samples and documentation to help with the development of COM modules and .NET assemblies that wrap Excel XLL add-ins.

The add-in functions in the library are available as COM and .NET methods to client programs that use the wrapper modules.

The wrapper objects can be used by clients written in any development environment that supports COM or .NET, including C++, Java, C#, Visual Basic and VBA.

Asynchronous functions

We've considerably improved the performance and scalability of the asynchronous function model. You can now place thousands of asynchronous functions in a spreadsheet without degrading performance.

Sample data feed application

We've added a new sample application which demonstrates how to integrate a data feed into an Excel add-in for high-performance real-time data add-in, written in C++, and which supports array real-time values as well as scalar values.

Portuguese language support

Help files can now be generated in any of three languages: English, French and now Portuguese.

Value Lists

The Value List Editor is now easier to use. You can copy and paste data to and from the dialog, so it's easy to edit lists in source code or in Excel, and paste them into the Value List Editor.