pyExcelerator and multiple worksheets

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


On Jun 12, 10:58 am, aneesh.goel.r... at gmail.com 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
    http://groups.google.com/group/python-excel

Cheers,
John




More information about the Python-list mailing list