Class: SimpleTextExtract::FormatExtractor::Xls

Inherits:
Base
  • Object
show all
Defined in:
lib/simple_text_extract/format_extractor/xls.rb

Instance Attribute Summary

Attributes inherited from Base

#file

Instance Method Summary collapse

Methods inherited from Base

#initialize, #missing_dependency?

Constructor Details

This class inherits a constructor from SimpleTextExtract::FormatExtractor::Base

Instance Method Details

#extractObject



6
7
8
9
10
11
12
13
14
15
16
17
# File 'lib/simple_text_extract/format_extractor/xls.rb', line 6

def extract
  require "spreadsheet"

  spreadsheet = Spreadsheet.open(file)
  text = []
  spreadsheet.worksheets.each do |sheet|
    text << sheet.name
    text << sheet.rows
  end

  text.flatten.join(" ")
end