#!/usr/bin/env python
# This example script was ported from Perl Spreadsheet::WriteExcel module.
# The author of the Spreadsheet::WriteExcel module is John McNamara
# <jmcnamara@cpan.org>
__revision__ = """$Id: images.py,v 1.9 2004/01/31 18:56:07 fufff Exp $"""
#######################################################################
#
# Example of how to insert images into an Excel worksheet using the
# Spreadsheet::WriteExcel insert_bitmap() method.
#
# reverse('(c)'), October 2001, John McNamara, jmcnamara@cpan.org
#
import pyXLWriter as xl
# Create a new workbook called simple.xls and add a worksheet
workbook = xl.Writer("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')
# Insert a basic image
worksheet1.write('A10', "Image inserted into worksheet.")
worksheet1.insert_bitmap('A1', 'republic.bmp')
# Insert an image with an offset
worksheet2.write('A10', "Image inserted with an offset.")
worksheet2.insert_bitmap('A1', 'republic.bmp', 32, 10)
# Insert a scaled image
worksheet3.write('A10', "Image scaled: width x 2, height x 0.8.")
worksheet3.insert_bitmap('A1', 'republic.bmp', 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_bitmap()
worksheet4.set_column('A:A', 5)
worksheet4.set_column('B:B', hidden=True)
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_bitmap('A1', 'republic.bmp')
workbook.close()
|