在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).


在Excel中使用 Clojure 编程语言:Excel REPL

项目主页:http://www.open-open.com/lib/view/home/1432023134271