Sha256: 041d19e60cbbf32fdce86efc521b9fd98cb26a97cc68f46f1cc56ce8015abf9e
Contents?: true
Size: 714 Bytes
Versions: 2
Compression:
Stored size: 714 Bytes
Contents
# =DECALER(data!$B$1;0;0;NBVAL(data!$B:$B)-1;1) # =DECALER(data!$A$1;0;0;NBVAL(data!$A:$A)-1;1) sheet = xls.get_sheet 'data' id = "AAAAA" 100.times do |rownum| row = sheet.create_row(rownum) 20.times do |colnum| cell = row.create_cell(colnum) if colnum == 0 set_cell_value row, colnum, id.succ! # cell.set_cell_value(id.succ!) else set_cell_value row, colnum, rand() end end end i = xls.get_name_index 'Noms' noms = nil if i >= 0 noms = xls.get_name_at(i) end i = xls.get_name_index 'Valeurs' valeurs = nil if i >= 0 valeurs = xls.get_name_at(i) end puts noms.getNameName, noms.getRefersToFormula puts valeurs.getNameName, valeurs.getRefersToFormula
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
simple_view-0.0.2 | test/views/test-xls.poi.rb |
simple_view-0.0.1 | test/views/test-xls.poi.rb |