#!/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