Contents

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

##############################################################################
#
# A simple formatting example using WriteExcel.
#
# This program demonstrates the diagonal border cell format.
#
# reverse('©'), May 2004, John McNamara, [e-mail]
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, [e-mail]
#

require 'rubygems'
require 'writeexcel'

workbook  = WriteExcel.new('diag_border.xls')
worksheet = workbook.add_worksheet

format1   = workbook.add_format(:diag_type       => 1)
format2   = workbook.add_format(:diag_type       => 2)
format3   = workbook.add_format(:diag_type       => 3)
format4   = workbook.add_format(
                              :diag_type       => 3,
                              :diag_border     => 7,
                              :diag_color      => 'red'
            )

worksheet.write('B3',  'Text', format1)
worksheet.write('B6',  'Text', format2)
worksheet.write('B9',  'Text', format3)
worksheet.write('B12', 'Text', format4)

workbook.close

Version data entries

33 entries across 33 versions & 3 rubygems

Version	Path
writeexcel-0.6.12	examples/diag_border.rb
writeexcel-0.6.11	examples/diag_border.rb
writeexcel-0.6.10	examples/diag_border.rb
writeexcel-0.6.9	examples/diag_border.rb
writeexcel-0.6.8	examples/diag_border.rb
writeexcel-0.6.7	examples/diag_border.rb
writeexcel-0.6.6	examples/diag_border.rb
writeexcel-0.6.5	examples/diag_border.rb
writeexcel-0.6.4	examples/diag_border.rb
writeexcel-0.6.3	examples/diag_border.rb
writeexcel-0.6.2	examples/diag_border.rb
writeexcel-0.6.1	examples/diag_border.rb
writeexcel-0.6.0	examples/diag_border.rb