Contents

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

#######################################################################
#
# Example of how to hide a worksheet with Excel::Writer::XLSX.
#
# reverse('c'), April 2005, John McNamara, [e-mail]
# convert to ruby by Hideo, Nakamura, [e-mail]
#
require 'write_xlsx'

workbook   = WriteXLSX.new('hide_sheet.xlsx')
worksheet1 = workbook.add_worksheet
worksheet2 = workbook.add_worksheet
worksheet3 = workbook.add_worksheet

worksheet1.set_column('A:A', 30)
worksheet2.set_column('A:A', 30)
worksheet3.set_column('A:A', 30)

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

worksheet1.write(0, 0, 'Sheet2 is hidden')
worksheet2.write(0, 0, "Now it's my turn to find you.")
worksheet3.write(0, 0, 'Sheet2 is hidden')

workbook.close

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
write_xlsx-1.12.1	examples/hide_sheet.rb
write_xlsx-1.12.0	examples/hide_sheet.rb
write_xlsx-1.11.2	examples/hide_sheet.rb
write_xlsx-1.11.1	examples/hide_sheet.rb
write_xlsx-1.11.0	examples/hide_sheet.rb
write_xlsx-1.10.2	examples/hide_sheet.rb
write_xlsx-1.10.1	examples/hide_sheet.rb
write_xlsx-1.10.0	examples/hide_sheet.rb
write_xlsx-1.09.5	examples/hide_sheet.rb
write_xlsx-1.09.4	examples/hide_sheet.rb
write_xlsx-1.09.3	examples/hide_sheet.rb
write_xlsx-1.09.2	examples/hide_sheet.rb
write_xlsx-1.09.1	examples/hide_sheet.rb
write_xlsx-1.09.0	examples/hide_sheet.rb
write_xlsx-1.08.2	examples/hide_sheet.rb
write_xlsx-1.08.1	examples/hide_sheet.rb
write_xlsx-1.08.0	examples/hide_sheet.rb
write_xlsx-1.07.0	examples/hide_sheet.rb
write_xlsx-1.04.0	examples/hide_sheet.rb
write_xlsx-1.02.0	examples/hide_sheet.rb