Class: Roo::Csv

Inherits:
GenericSpreadsheet show all
Defined in:
lib/roo/csv.rb

Overview

The Csv class can read csv files (must be separated with commas) which then can be handled like spreadsheets. This means you can access cells like A5 within these files. The Csv class provides only string objects. If you want conversions to other types you have to do it yourself.

Constant Summary

Constants inherited from GenericSpreadsheet

GenericSpreadsheet::TEMP_PREFIX

Instance Attribute Summary

Attributes inherited from GenericSpreadsheet

#default_sheet, #header_line, #headers

Instance Method Summary collapse

Methods inherited from GenericSpreadsheet

#column, #each, #each_with_pagename, #empty?, #find, #first_column, #first_column_as_letter, #first_row, #info, #last_column, #last_column_as_letter, #last_row, #longest_sheet, #method_missing, #parse, #reload, #row, #row_with, #set, #sheet, #to_csv, #to_matrix, #to_xml, #to_yaml

Constructor Details

#initialize(filename, packed = nil, file_warning = :error, tmpdir = nil) ⇒ Csv

Returns a new instance of Csv.



11
12
13
14
15
16
17
18
19
20
 
# File 'lib/roo/csv.rb', line 11

def initialize(filename, packed=nil, file_warning=:error, tmpdir=nil)
  @filename = filename
  @cell = Hash.new
  @cell_type = Hash.new
  @cells_read = Hash.new
  @first_row = Hash.new
  @last_row = Hash.new
  @first_column = Hash.new
  @last_column = Hash.new
end

Dynamic Method Handling

This class handles dynamic methods through the method_missing method in the class Roo::GenericSpreadsheet

Instance Method Details

#cell(row, col, sheet = nil) ⇒ Object 



28
29
30
31
32
33
 
# File 'lib/roo/csv.rb', line 28

def cell(row, col, sheet=nil)
  sheet ||= @default_sheet
  read_cells(sheet) unless @cells_read[sheet]
  row,col = normalize(row,col)
  @cell[[row,col]]
end

#cell_postprocessing(row, col, value) ⇒ Object 



42
43
44
 
# File 'lib/roo/csv.rb', line 42

def cell_postprocessing(row,col,value)
  value
end

#celltype(row, col, sheet = nil) ⇒ Object 



35
36
37
38
39
40
 
# File 'lib/roo/csv.rb', line 35

def celltype(row, col, sheet=nil)
  sheet ||= @default_sheet
  read_cells(sheet) unless @cells_read[sheet]
  row,col = normalize(row,col)
  @cell_type[[row,col]]
end

#sheets ⇒ Object

Returns an array with the names of the sheets. In Csv class there is only one dummy sheet, because a csv file cannot have more than one sheet.



24
25
26
 
# File 'lib/roo/csv.rb', line 24

def sheets
  ['default']
end