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
VERSION | = | '0.7.3' | The version of Spreadsheet you are using. |
client_encoding | [RW] |
Parses a Spreadsheet Document and returns a Workbook object. At present, only Excel-Documents can be read.