Class: RubyXL::Worksheet

Inherits:
Object
  • Object
show all
Defined in:
lib/merge_excel/extensions/rubyXL/worksheet.rb

Instance Method Summary collapse

Instance Method Details

#add_row_at(row_idx, cells_array) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
 
# File 'lib/merge_excel/extensions/rubyXL/worksheet.rb', line 9

def add_row_at(row_idx, cells_array)
  cells_array.to_a.each_with_index do |cell, col_idx|
    if cell.is_a? DateTime
      c = add_cell(row_idx, col_idx)
      c.set_number_format('yyyy-mm-dd')
      c.change_contents(cell)
    else
      add_cell(row_idx, col_idx, cell)
    end
  end
end

#row_values(row_idx, from_col_idx = 0, to_col_idx = -1)) ⇒ Object 



3
4
5
6
7
 
# File 'lib/merge_excel/extensions/rubyXL/worksheet.rb', line 3

def row_values(row_idx, from_col_idx=0, to_col_idx=-1)
  values = sheet_data[row_idx] && sheet_data[row_idx].cells[from_col_idx..to_col_idx].map{|c| c && c.value}
  return nil if values.nil? || values.empty? || values.all?(&:nil?)
  values
end