Add a basic example of opening an xls 2003 spreadsheet to readme

[equivalentideas]

Thanks for the gem. I'm trying to open a Microsoft Excel 97-2004 Worksheet with:

book = Roo::Spreadsheet.open 'AusTender-Contract-Notice-Export_20150613_183324.xls', extension: :xls

and getting the error Ole::Storage::FormatError: OLE2 signature is invalid.

I'm not confident I'm using this correctly, a simple example of opening a file would make a very useful addition to the readme. Anything would be better than nothing ;)

Thanks again

[JackWells]

After installing the gem, does one just add "require 'roo-xls" (along with require "roo") to your class, and then use roo on the xls file as you would with other speadsheet files, which are supported by roo alone? That's just a guess, so even a few lines of 'how to use it' would be very helpful.

[JoseMPena]

After installing the gem, does one just add "require 'roo-xls" (along with require "roo") to your class, and then use roo on the xls file as you would with other speadsheet files, which are supported by roo alone? That's just a guess, so even a few lines of 'how to use it' would be very helpful.

I see the issue is closed. is this the correct usage, then?

[tgturner]

@JoseMPena I apologize, I closed this because it was old. The correct usage is like this:

begin
  require "bundler/inline"
rescue LoadError => e
  $stderr.puts "Bundler version 1.10 or later is required. Please update your Bundler"
  raise e
end

gemfile(true) do
  source "https://rubygems.org"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  gem "roo-xls"
  gem "minitest"
end

require "roo-xls"
require "minitest/autorun"

class BugTest < Minitest::Test
  def test_stuff
    sheet = Roo::Excel.new('/Users/gturner/downloads/table.xls')
    puts sheet.row(1)
  end
end

You only need the roo-xls gem as it will require the roo gem. You need to use the Roo::Excel class to operate on excel spreadsheets. I'll reopen this issue to add some example to the docs.