配列を簡単にxlsxに出す(RubyXL)

Ruby

ちょー簡単に書き出してみましょう。

コード†

require 'rubyXL'

class Array
 def _to_xlsx(filename,ptns)
   book = RubyXL::Workbook.new
   sheet = book[0]
   sheet.sheet_name = filename.split("/").last
   (0..ptns.length-1).each{|i|
     sheet.add_cell(0,i,ptns[i])
   }
   (0..self.length-1).each{|j|
     s = self[j]
     if s.class != Array
       s = s.split("\t")
     end
     (0..s.length-1).each{|i|
       sheet.add_cell(j+1,i,s[i])
     }
   }
   book.write(filename)
 end
end

配列を作る。†

 s = [
   [0ヵ月","136.4","124.6","121.7"],
   ["11ヵ月","141.7","128.5","125.2"]
 ]

呼び出す。†

 fn = "sample.xlsx"
 s._to_xlsx(fn,["10歳","平均身長","-2SD","-2.5SD"])

結果†

→ブログ(みかづきの色々)

→地震集計(更新停止中)

→バイク専科(テスト中)

→バイク関係

→City

→セリオ

→古い創作物待避所

→古い記録

→記録2

最新の20件