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
        
        first_row = if t.properties.crop
          t.properties.crop.first + 1
        else
          t.properties.skip + 1
        end
          
        last_row = if t.properties.crop
          t.properties.crop.last
        else
          spreadsheet.last_row
        end
        
        if t.properties.output_class == ::Array
          (first_row..last_row).each do |y|
            output = (1..spreadsheet.last_column).map do |x|
              assume_utf8 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
          headers = {}
          if t.properties.use_first_row_as_header?
            (1..spreadsheet.last_column).each do |x|
              v = spreadsheet.cell(first_row, x)
              v = spreadsheet.cell(first_row - 1, x) if v.blank? # look up
              if v.present?
                v = assume_utf8 v
                headers[v] = x # 'foobar' is found at column 6
              end
            end
            # "advance the cursor"
            first_row += 1
          else
            t.properties.headers.each_with_index do |k, i|
              headers[k] = i + 1
            end
          end
          (first_row..last_row).each do |y|
            output = ::ActiveSupport::OrderedHash.new
            headers.each do |k, x|
              output[k] = assume_utf8 spreadsheet.cell(y, x).to_s.gsub(/<[^>]+>/, '').strip
            end
            yield output if t.properties.keep_blank_rows or output.any? { |k, v| v.present? }
          end
        end
      ensure
        t.local_file.cleanup
      end
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
remote_table-1.3.0	lib/remote_table/format/mixins/processed_by_roo.rb