[Numpy-discussion] [ANN] NumPy 1.0b4 now available

schaffer at optonline.net schaffer at optonline.net
Sun Aug 27 15:17:50 CDT 2006


we have an Excel parser class with a method convert2RecArrayD that:

1. takes as input an Excel file name, plus an optional cell washing function (see below)

2. creates a recarray for each worksheet (we use UsedRange for the range of cells)
in the spreadsheet (via array()) and adds to a Python dict with keyword the name of the worksheet. the column -- errr field -- names are grabbed from the first row in each worksheet.

3. each cell in the spreadsheet is run thru the optional (else default) washer function. the default does unicode conversion plus some string.strip'ping 

we are using the spreadsheets as Resource files for a database application. so we are 
only reading the spreadsheets, not writing to them.

if this is useful, we'd be happy to put it somewhere useful.

Les

----- Original Message -----
From: Alan G Isaac <aisaac at american.edu>
Date: Sunday, August 27, 2006 3:55 pm
Subject: Re: [Numpy-discussion] [ANN] NumPy 1.0b4 now available


> If your Excel parsing has general application and 
> illustrates applications beyond say 
> http://www.bigbold.com/snippets/posts/show/2036
> maybe you could post a URL to some code.





More information about the Numpy-discussion mailing list