Contents

require "rubygems"
require "surpass"

font0 = Font.new
font0.name = 'Times New Roman'
font0.struck_out = true
font0.bold = true

style0 = StyleFormat.new
style0.font = font0


book = Workbook.new
ws0 = book.add_sheet('0')

ws0.write(1, 1, 'Test', style0)

0.upto(13) do |i|
    borders = Borders.new
    borders.left = i
    borders.right = i
    borders.top = i
    borders.bottom = i

    style = StyleFormat.new
    style.borders = borders

    ws0.write(i, 2, '', style)
    ws0.write(i, 3, hex(i), style0)
end

ws0.write_merge(5, 8, 6, 10, "")

book.save(__FILE__.gsub(/rb$/, "xls"))

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
surpass-0.0.6	examples/blanks.rb