class RubyXL::Worksheet
Public Instance Methods
add_row_at(row_idx, cells_array)
click to toggle source
# 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)
click to toggle source
# 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