Spreadsheet::Excel Compatibility Layer. Drop-in replacement for Spreadsheet::Excel version <= 0.3.5.1
Spreadsheet::Encoding -- spreadheet -- 07.09.2011 -- mhatakeyama@ywesee.com Spreadsheet::Encoding -- spreadheet -- 03.07.2009 -- hwyss@ywesee.com
Future directions may include:
- support for mapping RGB values to "best fit" palette values
by Dan Caugherty github.com/dancaugherty/spreadsheet/compare/master...rgb
The Spreadsheet Library is designed to read and write Spreadsheet Documents. As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported.
require 'spreadsheet' book = Spreadsheet.open '/path/to/an/excel-file.xls' sheet = book.worksheet 0 sheet.each do |row| puts row[0] end
The version of Spreadsheet you are using.
Parses a Spreadsheet Document and returns a Workbook object. At present, only Excel-Documents can be read.
# File lib/spreadsheet.rb, line 61 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
Generated with the Darkfish Rdoc Generator 2.