Sha256: b42e6bd42bf749bc3400630332fabadf4cb2de0e09e9857a240475a62013df1b
Contents?: true
Size: 1.84 KB
Versions: 30
Compression:
Stored size: 1.84 KB
Contents
#!/usr/bin/ruby -w
# -*- coding: utf-8 -*-
#######################################################################
#
# Example of how to insert images into an Excel worksheet using the
# WriteExcel insert_image() method.
#
# reverse('©'), October 2001, John McNamara, jmcnamara@cpan.org
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, cxn03651@msj.biglobe.ne.jp
#
require 'rubygems'
require 'writeexcel'
# Create a new workbook called simple.xls and add a worksheet
workbook = WriteExcel.new("images.xls")
worksheet1 = workbook.add_worksheet('Image 1')
worksheet2 = workbook.add_worksheet('Image 2')
worksheet3 = workbook.add_worksheet('Image 3')
worksheet4 = workbook.add_worksheet('Image 4')
bp=1
# Insert a basic image
worksheet1.write('A10', "Image inserted into worksheet.")
worksheet1.insert_image('A1',
File.join(File.dirname(File.expand_path(__FILE__)), 'republic.png')
)
# Insert an image with an offset
worksheet2.write('A10', "Image inserted with an offset.")
worksheet2.insert_image('A1',
File.join(File.dirname(File.expand_path(__FILE__)), 'republic.png'),
32, 10
)
# Insert a scaled image
worksheet3.write('A10', "Image scaled: width x 2, height x 0.8.")
worksheet3.insert_image('A1',
File.join(File.dirname(File.expand_path(__FILE__)), 'republic.png'),
0, 0, 2, 0.8
)
# Insert an image over varied column and row sizes
# This does not require any additional work
# Set the cols and row sizes
# NOTE: you must do this before you call insert_image()
worksheet4.set_column('A:A', 5)
worksheet4.set_column('B:B', nil, nil, 1) # Hidden
worksheet4.set_column('C:D', 10)
worksheet4.set_row(0, 30)
worksheet4.set_row(3, 5)
worksheet4.write('A10', "Image inserted over scaled rows and columns.")
worksheet4.insert_image('A1',
File.join(File.dirname(File.expand_path(__FILE__)), 'republic.png')
)
workbook.close
Version data entries
30 entries across 30 versions & 3 rubygems