配列を簡単にxlsxに出す(RubyXL) の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• 配列を簡単にxlsxに出す(RubyXL) へ行く。

#author("2018-05-17T13:18:20+09:00","default:yakumo_murakami","yakumo_murakami")
[[Ruby]]

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

* コード [#c9eda055]

 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

* 配列を作る。 [#gf8c5fa9]

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

* 呼び出す。 [#l0a93cd2]

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

* 結果 [#g081eab7]

,"10歳","平均身長","-2SD","-2.5SD"
,"0ヵ月","136.4","124.6","121.7"
,"11ヵ月","141.7","128.5","125.2"