Sha256: b874b38deb9923293cc6bfc717a15ae8f63eb1ea636c831056018e2d02a57365
Contents?: true
Size: 1.86 KB
Versions: 38
Compression:
Stored size: 1.86 KB
Contents
#!/usr/bin/ruby -w
# -*- coding: utf-8 -*-
###############################################################################
#
# Simple example of how to add an externally created chart to a Spreadsheet::
# WriteExcel file.
#
#
# This example adds a pie chart extracted from the file Chart2.xls as follows:
#
# perl chartex.pl -c=demo1 Chart1.xls
#
#
# reverse('ｩ'), September 2004, John McNamara, jmcnamara@cpan.org
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, cxn03651@msj.biglobe.ne.jp
#
require 'writeexcel'
workbook = WriteExcel.new("demo2.xls")
worksheet = workbook.add_worksheet
# Add the chart extracted using the chartex utility
chart = workbook.add_chart_ext('demo201.bin', 'Chart1')
# Link the chart to the worksheet data using a dummy formula.
worksheet.store_formula('=Sheet1!A1')
# Add some extra formats to cover formats used in the charts.
chart_font_1 = workbook.add_format(:font_only => 1)
chart_font_2 = workbook.add_format(:font_only => 1)
chart_font_3 = workbook.add_format(:font_only => 1)
chart_font_4 = workbook.add_format(:font_only => 1)
chart_font_5 = workbook.add_format(:font_only => 1)
# Add all other formats (if any).
bold = workbook.add_format(:bold => 1)
# Adjust column widths and add some headers
worksheet.set_column('A:B', 20)
worksheet.write('A1', 'Module', bold)
worksheet.write('B1', 'No. of lines', bold)
# Add data to range that the chart refers to.
data = [
['BIFFwriter.pm', 275],
['Big.pm', 99],
['Chart.pm', 269],
['Format.pm', 724],
['Formula.pm', 1410],
['OLEwriter.pm', 447],
['Utility.pm', 884],
['Workbook.pm', 1925],
['WorkbookBig.pm', 112],
['Worksheet.pm', 3945]
]
worksheet.write_col('A2', data )
workbook.close
Version data entries
38 entries across 38 versions & 3 rubygems