Sha256: cd17a48adaa66f9832d713cd36ffaa7884a240d55766c5be8c33afb498f1186e

Contents?: true

Size: 1.06 KB

Versions: 2

Compression:

Stored size: 1.06 KB

Contents

= Simple Spreadsheet Extractor

Authors::    Stuart Owen
Version::    0.2
Contact::    mailto:stuart.owen@manchester.ac.uk
Licence::    BSD (See LICENCE or http://www.opensource.org/licenses/bsd-license.php)
Copyright::  (c) 2010 The University of Manchester, UK


== Synopsis

This is a simple gem that provides a facility to read and XLS or XLSX spreadsheet and produce an XML representation of its contents

Internally it uses Apache POI, using the sister [http://github.com/myGrid/simple-spreadsheet-extractor] tool.

This is a simple tool developed for use within SysMO-DB[http://www.sysmo-db.org].

== Installation

Java 1.6 (JRE) is required.

[sudo] gem install simple-spreadsheet-extractor

== Usage

* require 'spreadsheet-extractor'
* include the module SysMODB::SpreadsheetExtractor
* pass an IO object to the method spreedsheet_to_xml which responds with the XML for the contents of the sheet.
  
e.g.

   require 'rubygems'
   require 'spreadsheet-extractor'

   include SysMODB::SpreadsheetExtractor

   f=open("/tmp/test-spreadsheet.xls")
   puts spreadsheet_to_xml f

Version data entries

2 entries across 2 versions & 1 rubygems

Version Path
simple-spreadsheet-extractor-0.2.1 README.rdoc
simple-spreadsheet-extractor-0.2 README.rdoc