Method: RubyXL::WorksheetConvenienceMethods#delete_row

Defined in:

lib/rubyXL/convenience_methods/worksheet.rb

#delete_row(row_index = 0) ⇒ Object

# File 'lib/rubyXL/convenience_methods/worksheet.rb', line 126

def delete_row(row_index=0)
  validate_workbook
  validate_nonnegative(row_index)

  deleted = sheet_data.rows.delete_at(row_index)

  # Update row number of each cell
  row_index.upto(sheet_data.size - 1) { |index|
    row = sheet_data[index]
    row && row.cells.each{ |c| c.row -= 1 unless c.nil? }
  }

  # Update row number of merged cells
  if self.merged_cells then
    merged_cells.delete_if { |mc| mc.ref.row_range == (row_index..row_index) }
    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,
      )
    }
    merged_cells.delete_if { |mc| mc.ref.single_cell? }
  end

  return deleted
end