Sha256: 745d876d30d9d0698e1ab1c17f03e9c3e84c5d9d5cb4e8b46316ea997917245e
Contents?: true
Size: 1.34 KB
Versions: 2
Compression:
Stored size: 1.34 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
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
write_xlsx-1.10.0 | examples/sparklines1.rb |
write_xlsx-1.09.5 | examples/sparklines1.rb |