pyExcelerator and multiple worksheets

aneesh.goel.rbtx at gmail.com aneesh.goel.rbtx at gmail.com
Tue Jun 12 02:58:05 CEST 2007


I'm using pyExcelerator to take a folder of CSV files and create Excel
workbooks for all of them, then generate an Excel workbook with the
data from all of them.

Everything up until here works great; next, I make a second worksheet
on the last workbook which has summary details regarding the previous
worksheet.  Here I run into a problem.  The Excel form

AVERAGE(Data!E5:E3053)

where Data is the name of the worksheet being referenced (Summary is
the name of the worksheet where the formula is entered) isn't
recognized when I call Formula().  Currently I'm just writing the
string =AVERAGE(Data!E5:E3053) into the cell, but this doesn't get
automatically evaluated; there are multiple instances of this
formatting in use and when used with a larger source folder,
evaluating each cell by hand becomes a significant problem.

Without any documentation for pyExcelerator I turned to the examples
provided, but none of them seemed to use cross-worksheet formulas.
Does anybody know how to fix this, or alternatively know a different
package I could use?  I found xlrd but as that is read-only it doesn't
seem to solve the problem, unless there's some insane and creative way
to use xlrd and pyExcelerator together to solve this.

Thanks in advance!
--Aneesh




More information about the Python-list mailing list