examples/images.rb in writeexcel-0.5.0 vs examples/images.rb in writeexcel-0.6.0

@@ -1,63 +1,63 @@
-#!/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, [e-mail]
-#
-# original written in Perl by John McNamara
-# converted to Ruby by Hideo Nakamura, [e-mail]
-#
-
-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
+#!/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, [e-mail]
+#
+# original written in Perl by John McNamara
+# converted to Ruby by Hideo Nakamura, [e-mail]
+#
+
+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