F# assemblies can be compiled with a -standalone switch that embeds the F# runtime into the assembly, and allows it to run without requiring additional assemblies.

There is a bug in Excel-DNA v 0.30 that prevents such assemblies to be loaded by Excel-DNA. The workaround is to:
  1. mark functions and macros that are to be exported with explicit [<ExcelFunction>] or [<ExcelCommand>] attributes, and
  2. set the 'ExplicitExports' flag on the ExternalLibrary tag in the .dna file:
<ExternalLibrary Path="..." ExplicitExports="true" />.

With these cahnges, F# libraries can be compiled with the standalone switch, and used as Excel-DNA add-ins without requiring additional F# libraries on the client.

Last edited Dec 19, 2012 at 10:45 AM by govert, version 1


No comments yet.