Python COM Examples - Revision history

PeterHarding at 01:37, 14 December 2009

2009-12-14T01:37:46Z

← Older revision		Revision as of 11:37, 14 December 2009
Line 1:		Line 1:
	=Examples=		=Examples=

	~~Try this~~ Python-based COM automation ~~“Hello World” code in XSI just for kicks!~~		Here is a simple Python-based COM automation 'Hello World' script.

	<pre>		<pre>
Line 12:		Line 12:
	sheet.Range("A1").Value = "Hello World!"		sheet.Range("A1").Value = "Hello World!"
	sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))		sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))
	book.SaveAs("c:\~~myBook~~.xls")		book.SaveAs("c:\simple_example.xls")

	sheet = None		sheet = None
Line 20:		Line 20:
	</pre>		</pre>

	~~You~~ will ~~have created a file~~ in ~~your~~ root C: drive called ~~myBook~~.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.		This will create an Excel spreadsheet in the root C:\ drive, called 'simple_example.xls'.

	<pre>		<pre>
Line 36:		Line 36:


	~~But for your problem:~~		=COM Automation of Internet Explorer=

	~~You are trying to read the page before it is completely loaded~~		A couple of examples using either a wait function or a simple sleep for synchronisation.

	either ~~add~~ a wait function or a simple sleep ~~(see below)~~

	<pre>		<pre>
			from win32com.client import Dispatch

	~~from win32com.client import Dispatch~~
	import time		import time

Line 62:		Line 60:
	<pre>		<pre>
	from win32com.client import Dispatch		from win32com.client import Dispatch

	import time		import time

PeterHarding at 01:32, 14 December 2009

2009-12-14T01:32:05Z

← Older revision		Revision as of 11:32, 14 December 2009
Line 60:		Line 60:
	or with a wait function		or with a wait function

	</pre>		<pre>
	from win32com.client import Dispatch		from win32com.client import Dispatch
	import time		import time

PeterHarding at 01:31, 14 December 2009

2009-12-14T01:31:47Z

← Older revision		Revision as of 11:31, 14 December 2009
Line 21:		Line 21:

	You will have created a file in your root C: drive called myBook.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.		You will have created a file in your root C: drive called myBook.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.

	~~============================================================================~~

	<pre>		<pre>
Line 42:		Line 40:
	You are trying to read the page before it is completely loaded		You are trying to read the page before it is completely loaded

			either add a wait function or a simple sleep (see below)

	~~either add a wait function or a simple sleep ( see below)~~		<pre>

	</pre>

	from win32com.client import Dispatch		from win32com.client import Dispatch
	import time		import time


	ie = Dispatch("InternetExplorer.Application")		ie = Dispatch("InternetExplorer.Application")


	ie.Navigate("https://secure.authorize.net/")		ie.Navigate("https://secure.authorize.net/")
	# ie.Visible = True		# ie.Visible = True



	time.sleep(1)		time.sleep(1)
	doc = ie.Document		doc = ie.Document


	print doc.body.innerHTML		print doc.body.innerHTML
Line 71:		Line 63:
	from win32com.client import Dispatch		from win32com.client import Dispatch
	import time		import time



	def wait(ie):		def wait(ie):
Line 79:		Line 69:
	while ie.Document.readyState != "complete":		while ie.Document.readyState != "complete":
	time.sleep(0.5)		time.sleep(0.5)


	ie = Dispatch("InternetExplorer.Application")		ie = Dispatch("InternetExplorer.Application")


	ie.Navigate("https://secure.authorize.net/")		ie.Navigate("https://secure.authorize.net/")
	# ie.Visible = True		# ie.Visible = True


	wait(ie)		wait(ie)


	doc = ie.Document		doc = ie.Document


	print doc.body.innerHTML		print doc.body.innerHTML

PeterHarding at 01:31, 14 December 2009

2009-12-14T01:31:09Z

← Older revision		Revision as of 11:31, 14 December 2009
Line 1:		Line 1:
	~~<pre>~~		=Examples=
	~~==========================================================================~~==

	Try this Python-based COM automation “Hello World” code in XSI just for kicks!		Try this Python-based COM automation “Hello World” code in XSI just for kicks!

			<pre>
	import win32com.client		import win32com.client
	from win32com.client import constants as c		from win32com.client import constants as c
Line 18:		Line 18:
	excel.Quit()		excel.Quit()
	excel = None		excel = None
			</pre>

	You will have created a file in your root C: drive called myBook.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.		You will have created a file in your root C: drive called myBook.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.
Line 23:		Line 24:
	============================================================================		============================================================================

			<pre>
	def index():		def index():
	import win32com.client		import win32com.client
Line 33:		Line 35:
	if __name__ == "__main__":		if __name__ == "__main__":
	print index()		print index()
			</pre>

	~~============================================================================~~

	But for your problem:		But for your problem:

	You are trying to read the page before it is completely loaded		You are trying to read the page before it is completely loaded

Line 42:		Line 45:
	either add a wait function or a simple sleep ( see below)		either add a wait function or a simple sleep ( see below)

			</pre>

	from win32com.client import Dispatch		from win32com.client import Dispatch
Line 60:		Line 64:

	print doc.body.innerHTML		print doc.body.innerHTML
			</pre>


	or with a wait function		or with a wait function

			</pre>
	from win32com.client import Dispatch		from win32com.client import Dispatch
	import time		import time
Line 92:		Line 95:

	print doc.body.innerHTML		print doc.body.innerHTML

	~~============================================================================~~
	</pre>		</pre>

PeterHarding at 06:58, 23 October 2009

2009-10-23T06:58:45Z

← Older revision		Revision as of 16:58, 23 October 2009
Line 98:		Line 98:

	[[Category:Python]]		[[Category:Python]]
	[[Category:~~Pywin~~]]		[[Category:PyWin]]
	[[Category:Development]]		[[Category:Development]]

PeterHarding at 02:59, 18 November 2008

2008-11-18T02:59:34Z

← Older revision		Revision as of 12:59, 18 November 2008
Line 98:		Line 98:

	[[Category:Python]]		[[Category:Python]]
			[[Category:Pywin]]
	[[Category:Development]]		[[Category:Development]]

PeterHarding at 08:30, 30 April 2008

2008-04-30T08:30:49Z

← Older revision		Revision as of 18:30, 30 April 2008
Line 94:		Line 94:

	============================================================================		============================================================================


	~~============================================================================~~


	~~============================================================================~~


	~~============================================================================~~


	~~============================================================================~~


	~~============================================================================~~


	~~============================================================================~~

	</pre>		</pre>

PeterHarding at 08:30, 30 April 2008

2008-04-30T08:30:29Z

← Older revision		Revision as of 18:30, 30 April 2008
Line 114:		Line 114:

	</pre>		</pre>


			[[Category:Python]]
			[[Category:Development]]

PeterHarding: New page:

 ============================================================================  Try this Python-based COM automation “Hello World” code in XSI just for kicks!  import win32com.clie...

2008-04-30T08:30:07Z

New page: <pre> ============================================================================ Try this Python-based COM automation “Hello World” code in XSI just for kicks! import win32com.clie...

New page

<pre>
============================================================================

Try this Python-based COM automation “Hello World” code in XSI just for kicks!

import win32com.client
from win32com.client import constants as c

excel = win32com.client.Dispatch("Excel.Application")
book = excel.Workbooks.Add()
sheet = book.Worksheets(1)
sheet.Range("A1").Value = "Hello World!"
sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))
book.SaveAs("c:\myBook.xls")

sheet = None
book = None
excel.Quit()
excel = None

You will have created a file in your root C: drive called myBook.xls that is an Excel file containing one cell in which the words “Hello World!” are written. Please note that this COM usage is not limited to Python. You can do this in whatever language that supports COM. I’ll leave it up to the reader to learn more about the specifics of the different COM objects that are out there.

============================================================================

def index():
import win32com.client
a=win32com.client.Dispatch('Excel.Application')
a.Visible = 1
a.Workbooks.Add()
a.ActiveSheet.Cells(1,1).Value = 'aha'
return "aha"

if __name__ == "__main__":
print index()

============================================================================

But for your problem:
You are trying to read the page before it is completely loaded

either add a wait function or a simple sleep ( see below)

from win32com.client import Dispatch
import time

ie = Dispatch("InternetExplorer.Application")

ie.Navigate("https://secure.authorize.net/")
# ie.Visible = True

time.sleep(1)
doc = ie.Document

print doc.body.innerHTML

or with a wait function

from win32com.client import Dispatch
import time

def wait(ie):
while ie.Busy:
time.sleep(0.5)
while ie.Document.readyState != "complete":
time.sleep(0.5)

ie = Dispatch("InternetExplorer.Application")

ie.Navigate("https://secure.authorize.net/")
# ie.Visible = True

wait(ie)

doc = ie.Document

print doc.body.innerHTML

============================================================================

============================================================================

============================================================================

============================================================================

============================================================================

============================================================================

============================================================================

</pre>