Is there any way to get Roo to accept StringIO obj

Question

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?

Answer 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.