plot grids in Excel to make wireframes

make_16_grids.rb

require 'win32ole'

xls = WIN32OLE.new("Excel.Application")
xls.visible = true
wb = xls.workbooks.add()
ws = wb.worksheets(1)

(1..16).each do |i|
  col = i * 3 -1
  ws.columns(col).cells(1).value = i
  ws.columns(col).borders.lineStyle = 2
  ws.columns(col).horizontalAlignment = 3
  ws.columns(col).interior.colorIndex = 19
  ws.columns(col).columnWidth = 4.38   # 40 px
  ws.columns(col-1).columnWidth = 0.77 # 10 px
  ws.columns(col+1).columnWidth = 0.77 # 10 px
end
dir = File.expand_path('.')
wb.saveAs(File.join(dir, "16_grids.xls"))