module Spreadsheet

Synopsis¶ ↑

The Spreadsheet Library is designed to read and write Spreadsheet Documents. As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported.

Example¶ ↑

require 'spreadsheet'

book = Spreadsheet.open '/path/to/an/excel-file.xls'
sheet = book.worksheet 0
sheet.each do |row| puts row[0] end

Spreadsheet::Encoding – spreadheet – 07.09.2011 – mhatakeyama@ywesee.com Spreadsheet::Encoding – spreadheet – 03.07.2009 – hwyss@ywesee.com

Spreadsheet::Excel Compatibility Layer. Drop-in replacement for Spreadsheet::Excel version <= 0.3.5.1

Future directions may include:

- support for mapping RGB values to "best fit" palette values

by Dan Caugherty github.com/dancaugherty/spreadsheet/compare/master…rgb

Constants

VERSION: The version of Spreadsheet you are using.

Attributes

client_encoding[RW]

enc_ignore[RW]

enc_translit[RW]

Public Class Methods

open(io_or_path, mode="rb+") { |open(fh)| ... } click to toggle source

Parses a Spreadsheet Document and returns a Workbook object. At present, only Excel-Documents can be read.

# File lib/spreadsheet.rb, line 63
def open io_or_path, mode="rb+"
  if io_or_path.respond_to? :seek
    Excel::Workbook.open(io_or_path)
  elsif block_given?
    File.open(io_or_path, mode) do |fh|
      yield open(fh)
    end
  else
    open File.open(io_or_path, mode)
  end
end

writer(io_or_path, type=Excel) click to toggle source

Returns a Writer object for the specified path. At present, only the Excel-Writer is available.

# File lib/spreadsheet.rb, line 78
def writer io_or_path, type=Excel
  Excel::Writer::Workbook.new io_or_path
end