Giter VIP home page Giter VIP logo
dev master prerelease release
Build Nuget Build Nuget Build Nuget Build Nuget

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

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 !

C++

  • You write your C++ functions
  • The interface genertor generates the Excel C API bindings from your C++ header files.

C#

  • 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

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 v143

Creating a C++ XLL for Excel with XLW

Creating a C++ XLL for Excel with XLW


xlwDotNet

Only VS2020 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>net6.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

xlw's Projects

xlw icon xlw

git repository for xlw - Excel xlls made easy

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.