On 6/17/05, Hughes, Chad O [EMAIL PROTECTED] wrote:
I have posed a more complete answer to your question, however, it is quite a
large and It is awaiting approval. For now, xlRight = -4152. You can find
this out by opening up Excel and typing the ALT-F11 combination. From there
use the
Question
please:
In the post, "How to
operate the excel by python," where did you find the codes for
HorizontalAlignment and VerticalAlignment (Center = -4108 and Bottom =
-4107)? I need the code for HorizontalAlignment = xlRight. Is there
a table somewhere that shows these codes?
Thanks
Title: Message
Ihave posed a more complete
answer to your question, however, it is quite a large and It is awaiting
approval. For now, xlRight = -4152. You can find this out by opening
up Excel and typing the ALT-F11 combination. From there use the
ObjectBrowser. For example if you type in
i want to compare the content in excel,but i don't know whick module to use!
can you help me?
Read Python programming on Win32 book, use win32api module. According
to Chad's advices about Excel (VBA) constants, you can find following
link usefull as well.
John Machin [EMAIL PROTECTED] wrote:
Rune Strand wrote:
The key is Python for Windows :
http://starship.python.net/crew/mhammond/win32/
See here for an Excel dispatch example:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/325735
When doing such operations, I generally save all
Rune Strand wrote:
The key is Python for Windows :
http://starship.python.net/crew/mhammond/win32/
See here for an Excel dispatch example:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/325735
When doing such operations, I generally save all the Excel files to CSV
files and do
John,
I wrote a script that autmates the conversion from XLS to CSV. It's
easy. But your points are still good. Thanks for making me aware the
xlrd module!
--
http://mail.python.org/mailman/listinfo/python-list
ÒÊÃÉɽÈË wrote:
i want to compare the content in excel,but i don't know whick module to use!
can you help me?
I noticed a package on PyPi today that might be useful to you:
http://www.python.org/pypi/xlrd/0.3a1
The homepage is a little brief, so I clipped their example from the
README:
Here are two scripts that I have had to build for a class that I teach. You
will either need to write the constants explicitly, or I can email neet the
constans module that I have built, for the second one to work. I will copy it
to the very end. If you have any questions, just let me know.
Sorry, I meant to spell check but I did not somehow.
Chad
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hughes, Chad O
Sent: Friday, June 10, 2005 10:01 AM
To: python-list@python.org
Subject: RE: how to operate the excel by python?
Here are two
i want to compare the content in excel,but i don't know whick module to use!
can you help me?
--
http://mail.python.org/mailman/listinfo/python-list
The key is Python for Windows :
http://starship.python.net/crew/mhammond/win32/
See here for an Excel dispatch example:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/325735
When doing such operations, I generally save all the Excel files to CSV
files and do the operations on them using
12 matches
Mail list logo