Method: RubyXL::WorksheetConvenienceMethods#insert_row

Defined in:
lib/rubyXL/convenience_methods/worksheet.rb

#insert_row(row_index = 0) ⇒ Object

Inserts row at row_index, pushes down, copies style from the row above (that’s what Excel 2013 does!) NOTE: use of this method will break formulas which reference cells which are being “pushed down”


73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
 
# File 'lib/rubyXL/convenience_methods/worksheet.rb', line 73

def insert_row(row_index = 0)
  validate_workbook
  ensure_cell_exists(row_index)

  old_row = new_cells = nil

  if row_index > 0 then
    old_row = sheet_data.rows[row_index - 1]
    if old_row then
      new_cells = old_row.cells.collect { |c|
                    if c.nil? then nil
                    else nc = RubyXL::Cell.new(:style_index => c.style_index)
                         nc.worksheet = self
                         nc
                    end
                  }
    end
  end

  row0 = sheet_data.rows[0]
  new_cells ||= Array.new((row0 && row0.cells.size) || 0)

  sheet_data.rows.insert(row_index, nil)
  new_row = add_row(row_index, :cells => new_cells, :style_index => old_row && old_row.style_index)

  # Update row values for all rows below
  row_index.upto(sheet_data.rows.size - 1) { |r|
    row = sheet_data.rows[r]
    next if row.nil?
    row.cells.each_with_index { |cell, c|
      next if cell.nil?
      cell.r = RubyXL::Reference.new(r, c)
    }
  }

  # Update merged cells for all rows below
  if self.merged_cells then
    merged_cells.each { |mc|
      next if mc.ref.row_range.last < row_index

      in_merged_cell = mc.ref.row_range.first < row_index
      mc.ref = RubyXL::Reference.new(
        mc.ref.row_range.first + (in_merged_cell ? 0 : 1),
        mc.ref.row_range.last + 1,
        mc.ref.col_range.first,
        mc.ref.col_range.last,
      )
    }
  end

  return new_row
end