#!/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: write_arrays.py,v 1.2 2004/01/31 19:35:02 fufff Exp $"""
#######################################################################
#
# Example of how to use the Spreadsheet::WriteExcel module to
# write 1D and 2D arrays of data.
#
# To find out more about array references refer(!!) to the perlref and
# perlreftut manpages. To find out more about 2D arrays or "list of
# lists" refer to the perllol manpage.
#
# reverse('(c)'), March 2002, John McNamara, jmcnamara@cpan.org
#
import pyXLWriter as xl
workbook = xl.Writer("write_arrays.xls")
worksheet1 = workbook.add_worksheet('Example 1')
# worksheet2 = workbook.add_worksheet('Example 2')
worksheet3 = workbook.add_worksheet('Example 3')
worksheet4 = workbook.add_worksheet('Example 4')
# worksheet5 = workbook.add_worksheet('Example 5')
worksheet6 = workbook.add_worksheet('Example 6')
worksheet7 = workbook.add_worksheet('Example 7')
worksheet8 = workbook.add_worksheet('Example 8')
format = workbook.add_format(color = 'red', bold = 1)
# Data arrays used in the following examples.
# undef values are written as blank cells (with format if specified).
#
array = ['one', 'two', None, 'four']
array2d = [
['maggie', 'milly', 'molly', 'may' ],
[13, 14, 15, 16 ],
['shell', 'star', 'crab', 'stone'],
]
# 1. Write a row of data using an array reference.
worksheet1.write('A1', array)
# 3. Write a row of data using an explicit write_row() method call.
# This is the same as calling write() in Ex. 1 above.
#
worksheet3.write_row('A1', array)
# 4. Write a column of data using the write_col() method call.
worksheet4.write_col('A1', array)
# 6. Write a 2D array in col-row order.
worksheet6.write('A1', array2d)
# 7. Write a 2D array in row-col order.
worksheet7.write_col('A1', array2d)
# 8. Write a row of data with formatting. The blank cell is also formatted.
worksheet8.write('A1', array, format)
workbook.close()
|