Contents

#!/usr/bin/env ruby
# -*- coding: utf-8 -*-

#######################################################################
#
# A simple example of how to use the WriteXLSX gem to
# demonstrate stenciling in an Excel xlsx file.
#
# reverse('c'), May 2012, John McNamara, [e-mail]
# converted to Ruby by Hideo NAKAMURA, [e-mail]
#

require 'write_xlsx'

workbook  = WriteXLSX.new('shape4.xlsx')
worksheet = workbook.add_worksheet

worksheet.hide_gridlines(2)

type = 'rect'
shape = workbook.add_shape(
      :type   => type,
      :width  => 90,
      :height => 90
                           )

(1..10).each do |n|
  # Change the last 5 rectangles to stars. Previously
  # inserted shapes stay as rectangles.
  type = 'star5' if n == 6
  shape.type = type
  shape.text = "#{type} #{n}"
  worksheet.insert_shape('A1', shape, n * 100, 50)
end

stencil = workbook.add_shape(
      :stencil => 1,     # The default.
      :width   => 90,
      :height  => 90,
      :text    => 'started as a box'
                             )
worksheet.insert_shape('A1', stencil, 100, 150)

stencil.stencil = 0
worksheet.insert_shape('A1', stencil, 200, 150)
worksheet.insert_shape('A1', stencil, 300, 150)

# Ooopa! Changed my mind.
# Change the rectangle to an ellipse (circle),
# for the last two shapes.
stencil.type = 'ellipse'
stencil.text = 'Now its a circle'

workbook.close

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
write_xlsx-1.00.0	examples/shape4.rb
write_xlsx-0.99.0	examples/shape4.rb
write_xlsx-0.97.0	examples/shape4.rb
write_xlsx-0.90.0	examples/shape4.rb
write_xlsx-0.89.0	examples/shape4.rb
write_xlsx-0.88.0	examples/shape4.rb
write_xlsx-0.87.0	examples/shape4.rb
write_xlsx-0.86.0	examples/shape4.rb
write_xlsx-0.85.11	examples/shape4.rb
write_xlsx-0.85.10	examples/shape4.rb
write_xlsx-0.85.9	examples/shape4.rb
write_xlsx-0.85.8	examples/shape4.rb
write_xlsx-0.85.7	examples/shape4.rb
write_xlsx-0.85.6	examples/shape4.rb
write_xlsx-0.85.5	examples/shape4.rb
write_xlsx-0.85.4	examples/shape4.rb
write_xlsx-0.85.3	examples/shape4.rb
write_xlsx-0.85.2	examples/shape4.rb
write_xlsx-0.85.1	examples/shape4.rb
write_xlsx-0.83.0	examples/shape4.rb