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?