This project is looking for developers to maintain and take the project forward
Using CI builds
To use CI builds add the following nuget feed:
<?xml version="1.0" encoding="utf-8"?> <configuration> <packageSources> <clear /> <add key="XLW" value="https://f.feedz.io/xlw/xlw/nuget/index.json" /> <add key="NuGet.org" value="https://api.nuget.org/v3/index.json" /> </packageSources> </configuration>
XLW aims to facilitate the development of Excel addins with ease. It attempts to do this by wrapping the old Excel XLL C API in essentially a facade which is simplier to consume hence leaving the developer to focus on the buisness logic. To this end it hides away intricacies of interfacing with the low level Excel C API.
The concept behind XLW's approach is simplicity. There is nothing clever here !
- You write your C++ functions
- The interface genertor generates the Excel C API bindings from your C++ header files.
- You write your C# functions
- The Dotnet Interface generator uses reflection to generate C++/CLI bindings for your C#
- The (C++) interface genertor generates the Excel C API bindings from your C++/CLI header files
It's really not more complicated than that. Moreover, the process should be very transparent and the entry cost for any developer to modify, update or fix XLW should be extremely low.
xlw is being updated.
This repo was originally forked from John's XLW repo which itself was imported from it's original home at SourceForge
This version will only support Visual Studio 2020 for now. Support for all previous Visual Studio versions has been dropped. All support for gcc has also been dropped.
Support is being added for building xlls against .NET 6 & .NET Framework 4.7.2
An initial dev nuget package for building C/C++ xlls is avaialable at xlw@nuget.
And a nuget package for building C# xlls is available at xlwDotNet@nuget.
xlw for building C++/C xlls has not changed much at this point. To build a C++ xll :
- Create an empty C++ DLL project.
- Add the xlw nuget package.
*Required MSVC Toolset v143
Creating a C++ XLL for Excel with XLW
Only VS2020 is supported right now. To build a C# xll :
- Create a new .NET Core library project.
- Open the .csproj file with a text editor and set the
<Project Sdk="Microsoft.NET.Sdk"> <PropertyGroup> <TargetFrameworks>net6.0</TargetFrameworks> <Platforms>x64</Platforms> </PropertyGroup> </Project>
- Add the xlwDotNet nuget package.