Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

锟斤拷锟絧ython锟斤拷锟斤拷Excel时锟皆讹拷锟斤拷锟斤拷锟斤拷锟皆碉拷锟斤拷锟斤拷

4 views
Skip to first unread message

workbooks

unread,
May 18, 2014, 12:22:50 AM5/18/14
to
�����pydev�б�д�������Excel�������޷���Excel������Զ��������Ա����ҵ�������Ķ��������������python���룺

1 import win32com.client as win32
2
3 if __name__ == '__main__':
4 strFileName = r"D:\test python.xlsx"
5 appExl = win32.Dispatch('Excel.Application')
6 appExl.Visible = True
7 wb = appExl.Workbooks.Open(strFileName)
8 ws = wb.ActiveSheet
9 strTmp = ws.Cells(1,1).Value
10 print "A1=%s" % strTmp

�����з��֣���win32com.client�������ÿ��Excel�����޷��ڶ����������������Զ��г�������������ԡ����磬��6�����������appExl.��Ͳ����Զ��г�Visible���ԣ�����Ҫ���ֹ�����������ԡ�
��7����䣬appExlҲ�޷��Զ�����������Workbooks��
���Ƕ�appExl�ֹ�����������ں�����������Զ��г����總��ͼ��ʾ����11���������Զ��г����ù������Visible��Workbooks����������Ȼ�Ǻ��鷳��
��β�����ExcelVBA���Զ��г���������������أ����񸽼�ͼ�ұ�����лл��

[upload=1][/upload]
--

[m [33m�� ��Դ:��ˮľ���� http://www.newsmth.net��[FROM: 111.161.79.*] [m

÷ɽ֮��

unread,
May 19, 2014, 7:03:59 AM5/19/14
to
锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟絭isible锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷诘锟斤拷锟斤拷裕锟斤拷锟斤拷锟较讹拷也锟斤拷锟斤拷郑锟斤拷锟斤拷pywin32啥锟斤拷锟睫癸拷

锟斤拷 锟斤拷 workbooks 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
: 锟斤拷锟斤拷锟絧ydev锟叫憋拷写锟斤拷锟斤拷锟斤拷锟紼xcel锟斤拷锟斤拷锟斤拷锟睫凤拷锟斤拷Excel锟斤拷锟斤拷锟斤拷远锟斤拷锟斤拷锟斤拷锟斤拷员锟斤拷锟斤拷业锟斤拷锟斤拷锟斤拷锟侥讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟絧ython锟斤拷锟诫：
: 1 import win32com.client as win32
: 2
: ...................
--

[m [34m锟斤拷 锟斤拷源:锟斤拷水木锟斤拷锟斤拷 http://m.newsmth.net锟斤拷[FROM: 180.99.51.*] [m

workbooks

unread,
May 19, 2014, 7:22:13 AM5/19/14
to
锟矫的ｏ拷谢谢锟斤拷


锟斤拷 锟斤拷 AntiWorldCup (梅山之锟斤拷) 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟絭isible锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷诘锟斤拷锟斤拷裕锟斤拷锟斤拷锟较讹拷也锟斤拷锟斤拷郑锟斤拷锟斤拷pywin32啥锟斤拷锟睫癸拷

锟斤拷 锟斤拷 workbooks 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
: 锟斤拷锟斤拷锟絧ydev锟叫憋拷写锟斤拷锟斤拷锟斤拷锟紼xcel锟斤拷锟斤拷锟斤拷锟睫凤拷锟斤拷Excel锟斤拷锟斤拷锟斤拷远锟斤拷锟斤拷锟斤拷锟斤拷员锟斤拷锟斤拷业锟斤拷锟斤拷锟斤拷锟侥讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟絧ython锟斤拷锟诫：
: 1 import win32com.client as win32
: 2
: ...................
--



--

[m [1;31m锟斤拷 锟斤拷源:锟斤拷水木锟斤拷锟斤拷 newsmth.net锟斤拷[FROM: 111.206.27.*] [m

÷ɽ֮��

unread,
May 19, 2014, 9:42:23 AM5/19/14
to
锟斤拷一锟姐都锟斤拷同时锟斤拷锟斤拷excel vba 锟疥窗锟节ｏ拷要锟斤拷什么锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟芥看锟斤拷锟斤拷锟斤拷

锟斤拷 锟斤拷 workbooks 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
: 锟矫的ｏ拷谢谢锟斤拷
:
: 锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷
: ...................
--

[m [35m锟斤拷 锟斤拷源:锟斤拷水木锟斤拷锟斤拷 http://m.newsmth.net锟斤拷[FROM: 180.99.52.*] [m

workbooks

unread,
May 19, 2014, 9:56:03 AM5/19/14
to

锟斤拷锟斤拷锟斤拷锟斤拷Python锟斤拷Excel锟斤拷锟斤拷锟饺较讹拷

锟杰凤拷锟狡硷拷锟斤拷锟斤拷锟斤拷氐慕滩模锟斤拷锟斤拷枪锟斤拷锟絇ython锟斤拷锟斤拷Excel/word锟侥ｏ拷谢谢锟斤拷



锟斤拷 锟斤拷 AntiWorldCup (梅山之锟斤拷) 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
锟斤拷一锟姐都锟斤拷同时锟斤拷锟斤拷excel vba 锟疥窗锟节ｏ拷要锟斤拷什么锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟芥看锟斤拷锟斤拷锟斤拷

锟斤拷 锟斤拷 workbooks 锟侥达拷锟斤拷锟斤拷锟结到: 锟斤拷
: 锟矫的ｏ拷谢谢锟斤拷
:
: 锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷
: ...................
--



0 new messages