Module Spreadsheet
In: lib/parseexcel/parser.rb
lib/parseexcel/parseexcel.rb
lib/spreadsheet/font.rb
lib/spreadsheet/datatypes.rb
lib/spreadsheet/workbook.rb
lib/spreadsheet/row.rb
lib/spreadsheet/formula.rb
lib/spreadsheet/encodings.rb
lib/spreadsheet/format.rb
lib/spreadsheet/worksheet.rb
lib/spreadsheet/writer.rb
lib/spreadsheet/column.rb
lib/spreadsheet/link.rb
lib/spreadsheet/compatibility.rb
lib/spreadsheet/excel.rb
lib/spreadsheet/excel/offset.rb
lib/spreadsheet/excel/workbook.rb
lib/spreadsheet/excel/row.rb
lib/spreadsheet/excel/writer/workbook.rb
lib/spreadsheet/excel/writer/biff8.rb
lib/spreadsheet/excel/writer/format.rb
lib/spreadsheet/excel/writer/worksheet.rb
lib/spreadsheet/excel/sst_entry.rb
lib/spreadsheet/excel/reader.rb
lib/spreadsheet/excel/worksheet.rb
lib/spreadsheet/excel/reader/biff8.rb
lib/spreadsheet/excel/reader/biff5.rb
lib/spreadsheet/excel/internals.rb
lib/spreadsheet/excel/internals/biff8.rb
lib/spreadsheet/excel/internals/biff5.rb
lib/spreadsheet/excel/error.rb
lib/spreadsheet.rb
Column Format Row Font Enumerable Worksheet\n[lib/spreadsheet/excel.rb\nlib/spreadsheet/worksheet.rb] Link Workbook Workbook\n[lib/spreadsheet/excel.rb\nlib/spreadsheet/excel/workbook.rb] SstEntry String Row Array Worksheet ExcelCompatibleWorkbook Format Worksheet Workbook DelegateClassSpreadsheet::Format Writer Compatibility Formula Reader\n[lib/parseexcel/parseexcel.rb\nlib/spreadsheet/excel/reader.rb\nlib/spreadsheet/excel/reader/biff5.rb\nlib/spreadsheet/excel/reader/biff8.rb] Error lib/spreadsheet/excel.rb lib/spreadsheet/link.rb lib/spreadsheet/formula.rb lib/spreadsheet/workbook.rb lib/spreadsheet/font.rb lib/spreadsheet/column.rb lib/spreadsheet/format.rb lib/spreadsheet/writer.rb lib/spreadsheet/row.rb Encodings lib/spreadsheet/excel.rb lib/spreadsheet/excel/row.rb lib/spreadsheet/excel/reader/biff5.rb lib/spreadsheet/excel/worksheet.rb lib/spreadsheet/excel/sst_entry.rb lib/spreadsheet/excel/error.rb lib/spreadsheet/excel/workbook.rb lib/spreadsheet/excel/writer/format.rb lib/spreadsheet/excel/writer/workbook.rb lib/spreadsheet/excel/writer/worksheet.rb Biff8 Writer Biff5 Biff8 Internals Offset Excel Datatypes ParseExcel Compatibility Spreadsheet dot/m_34_0.png

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

Methods

open   writer  

Classes and Modules

Module Spreadsheet::Compatibility
Module Spreadsheet::Datatypes
Module Spreadsheet::Encodings
Module Spreadsheet::Excel
Class Spreadsheet::Column
Class Spreadsheet::Font
Class Spreadsheet::Format
Class Spreadsheet::Formula
Class Spreadsheet::Link
Class Spreadsheet::Row
Class Spreadsheet::Workbook
Class Spreadsheet::Worksheet
Class Spreadsheet::Writer

Constants

VERSION = '0.6.4.1'   The version of Spreadsheet you are using.

Attributes

client_encoding  [RW] 

Public Class methods

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

[Source]

    # File lib/spreadsheet.rb, line 60
60:     def open io_or_path, mode="rb+", &block
61:       if io_or_path.respond_to? :seek
62:         Excel::Workbook.open(io_or_path)
63:       elsif block
64:         File.open(io_or_path, mode) do |fh|
65:           block.call open(fh)
66:         end
67:       else
68:         open File.open(io_or_path, mode)
69:       end
70:     end

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

[Source]

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

[Validate]