As an alternative to using Visual Studio, FCell has 3 built-in code editors: F#, C# and VB.NET.
Similar to using Excel VBA editor, you define your UDFs and ribbons directly in Excel and the source code is saved in the workbook.
You compile your code with
Build button and the customization is immediately loaded into Excel: ribbons and task panes will become visible and UDFs can be used in workbook cells.
You can repeat the process multiple times, on each
Build FCell will automatically unload previous customization and load the new one.
The code editor has its own menu:
Fileallows you to compile and save the editor source code into a dll.
Editallows you to comment and indent text in the editor. Completion List is a very useful function which shows a list of potential code completions, e.g. all classes which start with
Runis only enabled in F# and allows you to run code in F# Interactive mode.
F#can reload F# Interactive references or specify F# editor mode. F# editor can be in Compiled or Interactive mode.
You use #if to divide your F# code into sections:
COMPILEDsection will be compiled on
Buildand loaded into Excel as customization. The other section defines a script for F# interactive.