Method: RubyXL::Cell#change_contents

Defined in:
lib/rubyXL/cell.rb

#change_contents(data, formula = nil) ⇒ Object

changes contents of cell, with formula option



231
232
233
234
235
236
237
238
239
240
241
242
 
# File 'lib/rubyXL/cell.rb', line 231

def change_contents(data, formula=nil)
  validate_worksheet
  @datatype='str'
  if data.is_a?(Date) || data.is_a?(DateTime)
    data = @workbook.date_to_num(data)
  end
  if (data.is_a?Integer) || (data.is_a?Float)
    @datatype = ''
  end
  @value=data
  @formula=formula
end