zigxll-standaloneAlexJReid/zigxll-standalone
-N/A
Demonstrates usage of the ZigXLL package to add a simple custom function to Excel
1100
3
excel,excel-custom-functions,zig
build.zig.zonbuild.zig
View program on GitHubDependencies
Namexll
Commit
refsREADME
zigxll-standalone
A standalone Excel XLL add-in built with ZigXLL.
Usage
Once loaded (double click the built .xll - see below), you can use the custom functions in any Excel spreadsheet:
=dblit(42)
This will return 84 (doubles the input number).
Building the XLL
If starting from scratch you will need to fetch to get the hash and add that to your build.zig.zon. This has already been done for this repo.
zig fetch https://github.com/alexjreid/zigxll/archive/refs/tags/v0.2.4.tar.gz
zig build
The XLL will be output to zig-out/lib/standalone.xll.
Adding more functions
Add your Excel functions to src/functions.zig using the function in that file as a guide.
Try out the pre-built XLL
- Go to the Actions tab and click on the latest successful workflow run
- Scroll down to the very bottom and download the zigxll-standalone artifact
- Extract the XLL file from the zip to a safe location - desktop works
- You will need to unblock it. More info: https://support.microsoft.com/en-gb/topic/excel-is-blocking-untrusted-xll-add-ins-by-default-1e3752e2-1177-4444-a807-7b700266a6fb
- Double-click
standalone.xllto load it into Excel