Contents

# frozen_string_literal: true

module SimpleTextExtract
  module FormatExtractor
    class XlsX < Base
      def extract
        require "roo"

        spreadsheet = Roo::Spreadsheet.open(file, only_visible_sheets: true)

        text = []

        spreadsheet.each_with_pagename do |name, sheet|
          text << name
          1.upto(sheet.last_row.to_i) { |row| text << sheet.row(row) }
        end

        text.flatten.join(" ")
      end
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
simple_text_extract-2.0.0	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-1.3.0	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-1.2.0	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-1.1.0	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-1.0.2	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-1.0.1	lib/simple_text_extract/format_extractor/xls_x.rb
simple_text_extract-0.3.0	lib/simple_text_extract/format_extractor/xls_x.rb