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 <[EMAIL PROTECTED]> 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. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Numpy-discussion mailing list Numpy-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/numpy-discussion
