pyXLWriter - simple example code ?

Aurelio Martin Massoni amartin at wpsnetwork.com
Fri Aug 20 12:41:08 EDT 2004


Richard Shea wrote:
> Hi - Anyone out there who has a simple example using pyXLWriter
> (http://sourceforge.net/projects/pyxlwriter/) they are willing to
> share with the group ?
> 
> I'm interested in creating a .XLS which has multiple sheets within the
> workbook but I'm having real trouble getting started, I can create a
> Worksheet but can't figure out how to save it.
> 
> thanks
> 
> richard shea.

########################################################################

import pyXLWriter

wb = pyXLWriter.Workbook( 'test.xls' )
ws1 = wb.add_worksheet( 'First' )
ws2 = wb.add_worksheet( 'Second' )
ws1.write( "A1", "January" )
ws1.write( "A2", "February" )
ws1.write( "A3", "March" )
ws1.write( "B1", 1.25 )
ws1.write( "B2", 2.50 )
ws1.write( "B3", 1.80 )
wb.close()

########################################################################

Hope this helps

	Aurelio



More information about the Python-list mailing list