class Spreet::Handlers::CSV

Public Class Methods

read(file, options={}) click to toggle source

Read a CSV file and create its Spreet document

# File lib/spreet/handlers/csv.rb, line 9
def self.read(file, options={})
  spreet = Spreet::Document.new
  sheet = spreet.sheets.add
  ::CSV.foreach(file) do |row|
    sheet.row *row
  end
  return spreet
end
write(spreet, file, options={}) click to toggle source

Write a Spreet to a CSV file

# File lib/spreet/handlers/csv.rb, line 20
def self.write(spreet, file, options={})
  sheet = spreet.sheets[options[:sheet]||0]
  ::CSV.open(file, "wb") do |csv|
    sheet.each_row do |row|
      csv << row.collect{|c| c.text}
    end
  end
end