pyExcelerator and multiple worksheets

John Machin sjmachin at
Tue Jun 12 12:08:14 CEST 2007

On Jun 12, 10:58 am, aneesh.goel.r... at wrote:
> 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().

See my reply to your post on


More information about the Python-list mailing list