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