在Excel中使用 Clojure 编程语言:Excel REPL
jopen
9年前
提供一个完整的Clojure编程环境,提高你在Microsoft Excel中的工作效率。
Excel REPL能够在Excel轻松启动一个ClojureCLR Repl。简单安装成一个Excel Add-In来提供一些额外的Excel功能。
Load
=Load(A:A)
Concatenates the contents of selected cells and evaluates them in namespace SheetName. SheetName is the name of the current worksheet.
Export
(defn ^:export f [] ...) (defn ^:export g ([] "No Args") ([x] "One Arg")) (defn ^:export h [single-cell-argument [excel-array-argument]] ...) (require 'excel-repl.udf) (excel-repl.udf/export-fns) ;exports the above functions
excel-repl.udf/export-fnswill export as Excel user defined functions all functions with^:exportmetadata in the current namespace. Functions with a single arglist are simply exported as their name. Multiarity functions include the arity. In the example above f will export=F()and g will export=G0()and=G1(x).