Sha256: 73186b2b856387298073f8dcf1acc2b61ef0b74f198da295b66105272592e5c3

Contents?: true

Size: 1.25 KB

Versions: 7

Compression:

Stored size: 1.25 KB

Contents

require 'roo/generic_spreadsheet'
require 'roo/excel'

class ExcelExtended < Excel
  # def read_cells(sheet=nil)
  #   sheet = @default_sheet unless sheet
  #   raise ArgumentError, "Error: sheet '#{sheet||'nil'}' not valid" if @default_sheet == nil and sheet==nil
  #   raise RangeError unless self.sheets.include? sheet
  #   
  #   if @cells_read[sheet]
  #     raise "sheet #{sheet} already read"
  #   end
  #   
  #   worksheet = @workbook.worksheet(sheet_no(sheet))
  #   row_index=1
  #   worksheet.each(0) do |row| 
  #     (0..row.size).each do |cell_index|
  #       cell = row.at(cell_index)
  #       next if cell.nil?  #skip empty cells
  #       next if cell.class == Spreadsheet::Formula && cell.value.nil? # skip empty formula cells
  #       if date_or_time?(row, cell_index)
  #         vt, v = read_cell_date_or_time(row, cell_index)
  #       else
  #         vt, v = read_cell(row, cell_index)
  #       end
  #       formula = tr = nil #TODO:???
  #       col_index = cell_index + 1
  #       font = row.format(cell_index).font
  #       font.extend(ExcelFontExtensions)
  #       set_cell_values(sheet,row_index,col_index,0,v,vt,formula,tr,font)
  #     end #row
  #     row_index += 1
  #   end # worksheet
  #   @cells_read[sheet] = true
  # end
  
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version Path
simple-spreadsheet-0.1.1 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.1.0 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.0.6 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.0.5.4 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.0.5.3 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.0.5.2 lib/simple-spreadsheet/classes/excel_extended.rb
simple-spreadsheet-0.0.5.1 lib/simple_spreadsheet/classes/excel_extended.rb