Sha256: 72c9cda72ecb3dc95e1ed87c5fe461ba0acf7a427d5abc0cd873d69f0f04e4bc

Contents?: true

Size: 1.52 KB

Versions: 20

Compression:

Stored size: 1.52 KB

Contents

class Hash
  def write_excel(filename)
    generate_excel(filename) do |workbook|
      each do |sheet_name, sheet_data|
        workbook.add_worksheet(name: sheet_name) do |sheet|
          if sheet_data.is_a?(Hash)
            fields = sheet_data[:fields].map(&:to_s)
            sheet.add_row(fields, types: [:string] * fields.size)
            sheet_data[:data].each do |row|
              sheet.add_row(row.slice(*fields).values.map(&:to_s), types: [:string] * fields.size)
            end
          end

          if sheet_data.is_a?(Array)
            if sheet_data.size > 0 && sheet_data.first.is_a?(ActiveRecord::Base)
              fields = sheet_data.first.attributes.keys
              sheet.add_row(fields, types: [:string] * fields.size)
              sheet_data.each do |row|
                sheet.add_row(row.slice(*fields).values.map(&:to_s), types: [:string] * fields.size)
              end
            end

            if sheet_data.size > 0 && sheet_data.first.is_a?(Hash)
              fields = sheet_data.first.keys
              sheet.add_row(fields, types: [:string] * fields.size)
              sheet_data.each do |row|
                sheet.add_row(row.slice(*fields).values.map(&:to_s), types: [:string] * fields.size)
              end
            end

            if sheet_data.size > 0 && sheet_data.first.is_a?(Array)
              sheet_data.each do |row|
                sheet.add_row(row.map(&:to_s), types: [:string] * fields.size)
              end
            end
          end
        end
      end
    end
  end
end

Version data entries

20 entries across 20 versions & 1 rubygems

Version Path
arql-0.4.12 lib/arql/ext/hash.rb
arql-0.4.11 lib/arql/ext/hash.rb
arql-0.4.10 lib/arql/ext/hash.rb
arql-0.4.8 lib/arql/ext/hash.rb
arql-0.4.7 lib/arql/ext/hash.rb
arql-0.4.6 lib/arql/ext/hash.rb
arql-0.4.3 lib/arql/ext/hash.rb
arql-0.4.2 lib/arql/ext/hash.rb
arql-0.4.1 lib/arql/ext/hash.rb
arql-0.4.0 lib/arql/ext/hash.rb
arql-0.3.31 lib/arql/ext/hash.rb
arql-0.3.30 lib/arql/ext/hash.rb
arql-0.3.29 lib/arql/ext/hash.rb
arql-0.3.28 lib/arql/ext/hash.rb
arql-0.3.27 lib/arql/ext/hash.rb
arql-0.3.26 lib/arql/ext/hash.rb
arql-0.3.25 lib/arql/ext/hash.rb
arql-0.3.24 lib/arql/ext/hash.rb
arql-0.3.23 lib/arql/ext/hash.rb
arql-0.3.22 lib/arql/ext/hash.rb