Contents

import com.smartxls.ChartFormat;
import com.smartxls.ChartShape;
import com.smartxls.WorkBook;
import java.awt.Color;

##
##	HEADER
##
xls.set_sheet_name 0, 'Donnees'
xls.set_sheet 0
xls.set_text 0, 0, 'Site'
xls.set_text 0, 1, 'Signature'
xls.set_text 0, 2, 'Nom'
xls.set_text 0, 3, 'Prénom'
xls.set_text 0, 4, 'Profil'
xls.set_text 0, 5, 'Structure'
xls.set_text 0, 6, 'Cellule'
xls.set_text 0, 7, 'Actif'
xls.set_text 0, 8, 'Taux activité'
xls.set_text 0, 9, 'Nombre dossiers'
xls.set_text 0, 10, 'Poids dossiers (100%)'

col=11
# Code niveau dossier
JDataStorePRC::COD_NIV_DOS.each do |co_niv|
	xls.set_text 0, col, "NB dossiers #{co_niv}"
	col += 1
end

# Code niveau dossier
JDataStorePRC::EVENS_SIGN.each do |co_evt|
	xls.set_text 0, col, "NB dossiers #{co_evt}"
	col += 1
end

##
##	BODY
##

ligne = 1
10.times do |l|
	sign = "AAA"
	50.times do |c|
		if c == 2
			xls.set_text ligne, c, sign
		else
			xls.set_number ligne, c, rand()
		end
	end
	sign = sign.succ
	ligne +=1 
end

##
##	Chart
##
xls.insert_sheets 0,1
xls.set_sheet 0
xls.set_sheet_name 0, 'ChartSheet'

left = 1;
top = 7;
right =13;
bottom = 31;

# create chart with it's location
chart = xls.addChart left,top,right,bottom

chart.set_chart_type ChartShape::Column
chart.add_series
chart.setSeriesYValueFormula 0, "Donnees!$K$1:$K$#{ligne}"
# chart.setSeriesXValueFormula 0, "Donnees!$B$1:$B$#{ligne}"
chart.set_axis_title ChartShape::XAxis, 0, "Utilisateurs"
chart.set_axis_title ChartShape::YAxis, 0, "Poids dossiers"

chart.set_series_name 0, "Poids dossiers"
chart.set_title "Dossiers PRC"

xls.set_sheet 1
xls.move_sheet 0

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
simple_view-0.0.2	test/views/test-xls.smartxl.rb
simple_view-0.0.1	test/views/test-xls.smartxl.rb