1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

require 'axlsx'

package = Axlsx::Package.new
sheet = package.workbook.add_worksheet(name: 'lists')

sheet.add_row(['品名', '単価', '数量', '計'] )
sheet.add_row(['にんじん',    80, 1,      '=B2*C2'])

sheet.sheet_view.pane do |pane|
  pane.top_left_cell = "B2"
  pane.state = :frozen_split
  pane.y_split = 1
  pane.x_split = 1
  pane.active_pane = :bottom_right
end

package.serialize('test.xlsx')

1
2
3
4
5
6
7
8
9

sheet.add_row(
  [
    "1000",
    1000,
  ], types: [:string, :float])
)

# もしくは
sheet.rows[0].cells[0].type = [:string]

1
2
3
4
5

sheet.add_row [1, 2, '=A1+B1'], :formula_values => [nil, nil, 3]

#_もしくは
sheet.rows[0].cells[0].value         = "=A1+B1"
sheet.rows[0].cells[0].formula_value = "3"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

module BooleanEx
  refine TrueClass do
    def true.to_circle
      "○"
    end
  end

  refine FalseClass do
    def false.to_circle
      ""
    end
  end
end

using BooleanEx

true.to_circle # => "○"
false.to_circle # => ""

1
2
3
4
5
6

    users = Rails.cache.fetch("users", expires_in: 30.seconds) do
      User.all.to_a
    end

    # 消す
    Rails.cache.delete('users')

1

accepts_nested_attributes_for :対象のアソシエーション, allow_destroy: true

1
2

parent.childs.first.mark_for_destruction # 削除したいレコードに削除のマークをつける
parent.childs.save # => childsのfirstのものか削除される。

1

parent.childs.first.marked_for_destruction? # => true

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

meeting = Proc.new do |teacher, student|
 p "#{teacher}は#{student}くんとカレーについて話す"
end

fujii_meeting = meeting.curry.("藤井先生")

%w(田中 佐藤 斉藤 加藤).each(&fujii_meeting)
# => "藤井先生は田中くんとカレーについて話す"
# => "藤井先生は佐藤くんとカレーについて話す"
# => "藤井先生は斉藤くんとカレーについて話す"
# => "藤井先生は加藤くんとカレーについて話す"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

require 'axlsx'
require "securerandom"

package = Axlsx::Package.new
sheet = package.workbook.add_worksheet(name: 'lists')
sheet.sheet_protection.password = SecureRandom.uuid
locked = package.workbook.styles.add_style :locked => true
unlocked = package.workbook.styles.add_style :locked => false

sheet.add_row(['品名', '単価', '数量', '計'], style: unlocked )
sheet.add_row(['にんじん',    80, 1,      '=B2*C2'], style: unlocked)

sheet.rows[0].cells[0].style = locked # A1をロック(lock cell => A1)

package.serialize('test.xlsx')

1

{name: "藤井", age: 34, job: "developer"}.except(:age) # => { :name => "藤井", :job => "developer" }

1
2
3
4
5
6
7
8
9

  # lib/active_record/associations/collection_association.rb
  def remove_records(existing_records, records, method)
    records.each { |record| callback(:before_remove, record) }

    delete_records(existing_records, method) if existing_records.any?
    records.each { |record| target.delete(record) }

    records.each { |record| callback(:after_remove, record) }
  end

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

  # lib/active_record/associations/collection_association.rb
  def delete_or_destroy(records, method)
    records = records.flatten
    records.each { |record| raise_on_type_mismatch!(record) }
    existing_records = records.reject { |r| r.new_record? }

    if existing_records.empty?
      remove_records(existing_records, records, method)
    else
      transaction { remove_records(existing_records, records, method) }
    end
  end