class POI::Worksheets

Public Class Methods

new(workbook) click to toggle source
# File lib/poi/workbook/worksheet.rb, line 5
def initialize(workbook)
  @workbook = workbook
  @poi_workbook = workbook.poi_workbook
end

Public Instance Methods

[](index_or_name) click to toggle source
# File lib/poi/workbook/worksheet.rb, line 10
def [](index_or_name)
  worksheet = case
    when index_or_name.kind_of?(Numeric)
      @poi_workbook.get_sheet_at(index_or_name) || @poi_workbook.create_sheet
    else 
      @poi_workbook.get_sheet(index_or_name) || @poi_workbook.create_sheet(index_or_name)
  end
  Worksheet.new(worksheet, @workbook)
end
each() { |worksheet(get_sheet_at, workbook)| ... } click to toggle source
# File lib/poi/workbook/worksheet.rb, line 24
def each
  (0...size).each { |i| yield Worksheet.new(@poi_workbook.get_sheet_at(i), @workbook) }
end
size() click to toggle source
# File lib/poi/workbook/worksheet.rb, line 20
def size
  @poi_workbook.number_of_sheets
end