On Jun 12, 10:58 am, [EMAIL PROTECTED] 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 -- http://mail.python.org/mailman/listinfo/python-list