class ReadExcel::XLSReader::Worksheet

Public Class Methods

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

Public Instance Methods

name() click to toggle source
# File lib/read_excel/xls_reader.rb, line 9
def name
  @worksheet.name
end
row(n) click to toggle source
# File lib/read_excel/xls_reader.rb, line 13
def row(n)
  values = []
  if @worksheet.row(n)
    count = @worksheet.row(n).size
    (0...count).each do |col|
      cell = @worksheet.row(n)[col]
      if cell.class == Spreadsheet::Formula
        values << cell.value
      else
        values << cell
      end
    end
  end

  values
end