|
- Sub test()
- '需要安装ACTIVERUBY ,下载地址 http://www.artonx.org/data/asr/Ruby-2.1.1.msi
- Set ojs = CreateObject("scriptcontrol"): ojs.Language = "rubyscript"
- y = ojs.eval("def aa(aa,bb);$aa=aa.flatten;$bb=bb.flatten;end")
- y = ojs.Run("aa", Sheet1.Range("d4", [d4].End(4)).Value, Range("e4", [e4].End(4)).Value)
- y = ojs.eval("Dir.chdir('" & ThisWorkbook.Path & "');f=File.new('1.txt','w');f.puts ($bb-$aa).map(&:to_i);f.close")
- y = ojs.eval("($bb-$aa).each_slice(10).to_a")
- [i4].Resize(UBound(y) + 1, UBound(y, 2) + 1).NumberFormat = "@"
- [i4].Resize(UBound(y) + 1, UBound(y, 2) + 1) = y
- Set ojs = Nothing
- 'Stop
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|