Contents

require 'roo'
class RemoteTable
  class Format
    module ProcessedByRoo
      def each(&blk)
        spreadsheet = roo_class.new t.local_file.path, nil, :ignore
        spreadsheet.default_sheet = t.properties.sheet.is_a?(::Numeric) ? spreadsheet.sheets[t.properties.sheet] : t.properties.sheet
        if t.properties.output_class == ::Array
          (first_data_row..spreadsheet.last_row).each do |y|
            output = (1..spreadsheet.last_column).map do |x|
              spreadsheet.cell(y, x).to_s.gsub(/<[^>]+>/, '').strip
            end
            yield output if t.properties.keep_blank_rows or output.any? { |v| v.present? }
          end
        else
          keys = {}
          if t.properties.use_first_row_as_header?
            (1..spreadsheet.last_column).each do |x|
              keys[x] = spreadsheet.cell(header_row, x)
              keys[x] = spreadsheet.cell(header_row - 1, x) if keys[x].blank? # look up
            end
          else
            (1..spreadsheet.last_column).each do |x|
              keys[x] = t.properties.headers[x - 1]
            end
          end
          (first_data_row..spreadsheet.last_row).each do |y|
            output = (1..spreadsheet.last_column).inject(::ActiveSupport::OrderedHash.new) do |memo, x|
              if keys[x].present?
                memo[keys[x]] = spreadsheet.cell(y, x).to_s.gsub(/<[^>]+>/, '').strip
              end
              memo
            end
            yield output if t.properties.keep_blank_rows or output.any? { |k, v| v.present? }
          end
        end
      ensure
        t.local_file.delete
      end

      private

      def header_row
        1 + t.properties.skip
      end

      def first_data_row
        1 + header_row
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
remote_table-1.2.2	lib/remote_table/format/mixins/processed_by_roo.rb
remote_table-1.2.1	lib/remote_table/format/mixins/processed_by_roo.rb
remote_table-1.2.0	lib/remote_table/format/mixins/processed_by_roo.rb