Contents

#!/usr/bin/env ruby
# -*- coding: utf-8 -*-

#######################################################################
#
# Example of how to add sparklines to an Excel::Writer::XLSX file.
#
# Sparklines are small charts that fit in a single cell and are
# used to show trends in data. See sparklines2.pl for examples
# of more complex sparkline formatting.
#
# reverse ('(c)'), November 2011, John McNamara, [e-mail]
# convert to ruby by Hideo NAKAMURA, [e-mail]
#

require 'write_xlsx'

workbook  = WriteXLSX.new('sparklines1.xlsx')
worksheet = workbook.add_worksheet

# Some sample data to plot.
data = [
        [ -2, 2,  3,  -1, 0 ],
        [ 30, 20, 33, 20, 15 ],
        [ 1,  -1, -1, 1,  -1 ]
       ]

# Write the sample data to the worksheet.
worksheet.write_col('A1', data)


# Add a line sparkline (the default) with markers.
worksheet.add_sparkline(
                        {
                          :location => 'F1',
                          :range    => 'Sheet1!A1:E1',
                          :markers  => 1
    }
)

# Add a column sparkline with non-default style.
worksheet.add_sparkline(
                        {
                          :location => 'F2',
                          :range    => 'Sheet1!A2:E2',
                          :type     => 'column',
                          :style    => 12
                        }
                        )

# Add a win/loss sparkline with negative values highlighted.
worksheet.add_sparkline(
                        {
                          :location        => 'F3',
                          :range           => 'Sheet1!A3:E3',
                          :type            => 'win_loss',
                          :negative_points => 1
                        }
                        )

workbook.close

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
write_xlsx-1.00.0	examples/sparklines1.rb
write_xlsx-0.99.0	examples/sparklines1.rb
write_xlsx-0.97.0	examples/sparklines1.rb
write_xlsx-0.90.0	examples/sparklines1.rb
write_xlsx-0.89.0	examples/sparklines1.rb
write_xlsx-0.88.0	examples/sparklines1.rb
write_xlsx-0.87.0	examples/sparklines1.rb
write_xlsx-0.86.0	examples/sparklines1.rb
write_xlsx-0.85.11	examples/sparklines1.rb
write_xlsx-0.85.10	examples/sparklines1.rb
write_xlsx-0.85.9	examples/sparklines1.rb
write_xlsx-0.85.8	examples/sparklines1.rb
write_xlsx-0.85.7	examples/sparklines1.rb
write_xlsx-0.85.6	examples/sparklines1.rb
write_xlsx-0.85.5	examples/sparklines1.rb
write_xlsx-0.85.4	examples/sparklines1.rb
write_xlsx-0.85.3	examples/sparklines1.rb
write_xlsx-0.85.2	examples/sparklines1.rb
write_xlsx-0.85.1	examples/sparklines1.rb
write_xlsx-0.83.0	examples/sparklines1.rb