/xlw

git repository for xlw - Excel xlls made easy

Primary LanguageC++OtherNOASSERTION

dev master prerelease release
Build Nuget Build Nuget Build Nuget Build Nuget

If you have .NET 5 Preview installed but would also like to build xlls for .NET Core 3.1 then you must have .NET Core 3.1.2 installed. See dotnet/sdk#12911

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

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 2019 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 CORE & .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

xlw for building C++/C xlls has not changed much at this point. To build a C++ xll :

  1. Create an empty C++ DLL project.
  2. Add the xlw nuget package.

*Required MSVC Toolset v142

Creating a C++ XLL for Excel with XLW

Creating a C++ XLL for Excel with XLW


xlwDotNet

Only VS2019 is supported right now. To build a C# xll :

  1. Create a new .NET Core library project.
  2. Open the .csproj file with a text editor and set the TargetFramework and Platform for example
<Project Sdk="Microsoft.NET.Sdk">
  <PropertyGroup>
    <TargetFrameworks>net5.0</TargetFrameworks>
    <Platforms>x64</Platforms>
  </PropertyGroup>
</Project>
  1. Add the xlwDotNet nuget package.

Creating a C# XLL for Excel with XLW

Creating a C# XLL for Excel with XLW

... And Just Because We Can

Embedding ASP.NET Core (kestrel) in an xll

XLL with Embedded ASP.NET Core (Kestrel) - Built with XLW against .NET 5 Preview