4

I'm trying to write some unit tests which involves Roo reading Excel 2007 files. I have the Excel file in my unit test file as a hex string, which in turn is fed into a StringIO instance. I can't simply pass the StringIO object to Roo::Spreadsheet.open, since that function actually checks if the passed object is a File instance:

def open(file, options = {})
  file = File === file ? file.path : file

  # ...

and if it isn't, proceeds to assume it's a string. Manually specifying the extension doesn't help:

doc = Roo::Spreadsheet.open(file, extension: :xlsx)

Are there any clever ways of getting Roo to use the StringIO instance as a file?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Hubro
  • 56,214
  • 69
  • 228
  • 381

1 Answers1

1

It looks like this version of roo has support for this. Instead of checking explicitly if it's a File class, it checks in duck-typing style if it's a stream based on whether it responds to #seek. The relevant code is here and here.

Andrew Grimm
  • 78,473
  • 57
  • 200
  • 338
take
  • 319
  • 3
  • 8