Method: RubyXL::Workbook#add_worksheet

Defined in:
lib/rubyXL/objects/workbook.rb

#add_worksheet(name = nil) ⇒ Object

Create new simple worksheet and add it to the workbook worksheets

Parameters:

  • The (String) —

    name for the new worksheet

[View source]

490
491
492
493
494
495
496
497
498
499
500
501
502
 
# File 'lib/rubyXL/objects/workbook.rb', line 490

def add_worksheet(name = nil)
  if name.nil? then
    n = 0

    begin
      name = SHEET_NAME_TEMPLATE % (n += 1)
    end until self[name].nil?
  end

  new_worksheet = Worksheet.new(:workbook => self, :sheet_name => name)
  worksheets << new_worksheet
  new_worksheet
end