Rubyist Magazine - Win32OLE 活用法 【第 2 回】 Excel

“Rubyist Magazine - Win32OLE 活用法 【第 2 回】 Excel”

1| require 'win32ole' 2| 3| module Border 4| def linetype 5| @@linestyles ||= nil 6| if @@linestyles.nil? 7| @@linestyles = {} 8| %w(XlContinuous XlDash XlDashDot 9| XlDashDotDot XlDot XlDouble 10| XlLineStyleNone XlSlantDashDot).each do |linestyle| 11| v = Border.const_get(linestyle) 12| @@linestyles[v] = linestyle 13| end 14| end 15| return @@linestyles.fetch(self.LineStyle) {|key| key} 16| end 17| 18| def lineweight 19| @@lineweights ||= nil 20| if @@lineweights.nil? 21| @@linewights = {} 22| %w(XlHairline XlMedium 23| XlThick XlThin).each do |weight| 24| v = Border.const_get(weight) 25| @@linewights[v] = weight 26| end 27| end 28| return @@linewights.fetch(self.Weight) {|key| key } 29| end 30| end 31| 32| def getAbsolutePath filename 33| fso = WIN32OLE.new('Scripting.FileSystemObject') 34| return fso.GetAbsolutePathName(filename) 35| end 36| 37| def openExcelWorkbook f...

Full article: http://jp.rubyist.net/magazine/?0004-Win32OLE