用于Python的Excel模块 [英] Excel module for Python

查看:93
本文介绍了用于Python的Excel模块的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

嗨组,


我想知道哪个Excel模块适合Python使用?


谢谢

Sam

Hi group,

I m wondering which Excel module is good to be used by Python?

Thanks
Sam

推荐答案

sam写道:
我想知道哪个Excel模块适合Python使用?
I m wondering which Excel module is good to be used by Python?




只需使用Excel的COM界面。


另请参阅此页面以改善未来的响应:
http://www.catb.org/~esr /faqs/smart-questions.html


-Peter



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


2005年1月12日星期三15:18 :09 + 0800,sam< sa ***** @ authtec.com>写道:
On Wed, 12 Jan 2005 15:18:09 +0800, sam <sa*****@authtec.com> wrote:
我想知道哪个Excel模块适合Python使用?
I m wondering which Excel module is good to be used by Python?




如果你在Windows上,并且你有Excel ,然后用于Windows的Python

扩展[1]是您通过COM驱动Excel所需的全部内容。 O''Reilly's

Win32上的Python编程广泛地涵盖了COM脚本 - 和好运的
,驱动Excel就是他们使用的例子,COM

脚本章节是在线[2]。


您还需要了解Excel公开的对象和方法。

这些记录在Microsoft的网站[3]或Excel VBA

帮助,这是他们Office安装的可选部分。


-

干杯,

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



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写道:< br>
Simon Brunning wrote:
2005年1月12日星期三15:18:09 +0800,sam< sa ***** @ authtec.com>写道:
On Wed, 12 Jan 2005 15:18:09 +0800, sam <sa*****@authtec.com> wrote:
我想知道哪个Excel模块适合Python使用?
I m wondering which Excel module is good to be used by Python?



如果你在Windows上,并且你有Excel ,然后Python for Windows
扩展[1]是你通过COM驱动Excel所需要的。 O''Reilly's
Win32上的Python编程广泛涵盖COM脚本 - 并且好运,驱动Excel就是他们使用的例子,而COM
脚本章节是在线[2]。

你''还需要了解Excel公开的对象和方法。
这些都记录在Microsoft的网站[3]或Excel VBA
帮助中,这是他们Office的可选部分安装。


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.




不,我不使用MS窗口。我需要通过打印

数据生成Excel文件,就像Perl模块Spreadsheet :: WriteExcel一样。


谢谢

山姆



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


这篇关于用于Python的Excel模块的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆