Contents

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

#######################################################################
#
# Example of how to hide a worksheet with WriteExcel.
#
# reverse('©'), April 2005, John McNamara, [e-mail]
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, [e-mail]
#
require 'writeexcel'


workbook   = WriteExcel.new('hidden.xls')
worksheet1 = workbook.add_worksheet
worksheet2 = workbook.add_worksheet
worksheet3 = workbook.add_worksheet

# Sheet2 won't be visible until it is unhidden in Excel.
worksheet2.hide

worksheet1.write(0, 0, 'Sheet2 is hidden')
worksheet2.write(0, 0, 'How did you find me?')
worksheet3.write(0, 0, 'Sheet2 is hidden')

workbook.close

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
writeexcel-1.0.9	examples/hide_sheet.rb
writeexcel-1.0.8	examples/hide_sheet.rb
writeexcel-1.0.7	examples/hide_sheet.rb
writeexcel-1.0.6	examples/hide_sheet.rb
writeexcel-1.0.5	examples/hide_sheet.rb