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