Re: excel centering columns

2006-05-17 Thread Lance Hoffmeyer
Once I imported the EXCEL 10.0 library using 'makepy utility' everything worked fine. And, yes, my typing mistake. Should have been 'constants' and not 'constant' Lance -- http://mail.python.org/mailman/listinfo/python-list

Re: excel centering columns

2006-05-17 Thread Ben Finney
Lance Hoffmeyer <[EMAIL PROTECTED]> writes: > import win32com.client > import re > import codecs > import win32com.client.dynamic > import time > import datetime > from win32com.client.dynamic import Dispatch > from win32com.client import constants These statements create code objects (some of th

Re: excel centering columns

2006-05-17 Thread Lance Hoffmeyer
I did read the error message. I did not understand why 'constant' was not defined. In perl I did not have to run anything like 'makepy' to get constants to work. And no, I don't want to go back to perl. Python appears to integrate with packages more readily than perl does. I was unaware of 'ma

Re: excel centering columns

2006-05-17 Thread John Machin
> from win32com.client import constants > sh2.Columns(lastcol).HorizontalAlignment = constant.xlCenter > NameError: name 'constant' is not defined 1. So why not try reading the error message and fixing the problem instead of thrashing about madly? 2. You have run makepy on your Excel library, hav