Sha256: 6f9058804ea8f4f40c69c7f36c8fee22447033e3624d1b547f0942e357557b46
Contents?: true
Size: 1.64 KB
Versions: 2
Compression:
Stored size: 1.64 KB
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 |