Sha256: 8da9b830a536530d4b707d6231f28fa325ef4abf81666757ef66f19f9d36f54e
Contents?: true
Size: 1.76 KB
Versions: 12
Compression:
Stored size: 1.76 KB
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, jmcnamara@cpan.org
# convert to ruby by Hideo NAKAMURA, nakamura.hideo@gmail.com
#
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
12 entries across 12 versions & 1 rubygems