Hi group,
I m wondering which Excel module is good to be used by Python?
Thanks
Sam
解决方案sam wrote:I m wondering which Excel module is good to be used by Python?
Just use Excel''s COM interface.
See also this helpful page to improve future responses:
http://www.catb.org/~esr/faqs/smart-questions.html
-Peter
On Wed, 12 Jan 2005 15:18:09 +0800, sam wrote:I m wondering which Excel module is good to be used by Python?
If you are on Windows, and you have Excel, then the Python for Windows
extensions[1] are all you need to drive Excel via COM. O''Reilly''s
"Python Programming on Win32" covers COM scripting extensively - and
by good fortune, driving Excel is the example they use, and the COM
scripting chapter is on-line[2].
You''ll also need to know the objects and methods that Excel exposes.
These are documented on Microsoft''s web site[3], or in the Excel VBA
help, which is an optional part of they Office installation.
--
Cheers,
Simon B,
si***@brunningonline.net,
http://www.brunningonline.net/simon/blog/
[1] http://starship.python.net/crew/mhammond/
[2] http://www.oreilly.com/catalog/pytho...pter/ch12.html
[3] http://msdn.microsoft.com/library/en...celObjects.asp
Simon Brunning wrote:
On Wed, 12 Jan 2005 15:18:09 +0800, sam wrote:
I m wondering which Excel module is good to be used by Python?
If you are on Windows, and you have Excel, then the Python for Windows
extensions[1] are all you need to drive Excel via COM. O''Reilly''s
"Python Programming on Win32" covers COM scripting extensively - and
by good fortune, driving Excel is the example they use, and the COM
scripting chapter is on-line[2].
You''ll also need to know the objects and methods that Excel exposes.
These are documented on Microsoft''s web site[3], or in the Excel VBA
help, which is an optional part of they Office installation.
No, I don''t use MS windows. I need to generate Excel file by printing
data to it, just like Perl module Spreadsheet::WriteExcel.
thanks
Sam