Excel Object Model

[david brochu jr]

Hello,

 

I am trying to automate Excel and I cant seem to find out much relating to it's object model (in relation to Python)..seems as if its mostly covered by C and VB. Can anyone point me in the right direction? I am able to open excel, add information to cells, and then save and close the book opened. I was looking to get into formatting of cells, formulas, etc.

 

Below is the code i have now...any responces would help.

 

import PAM
import time
from win32com.client import Dispatch    #this is needed to open an Excel file
execfile('c:\\Python24\\scripts\\PAM.py')
f = open('c:\python24\scripts\urls.txt','r')  #opens list of urls to be tested
xlApp = Dispatch("Excel.Application")
xlApp.Visible = 0
xlApp.Workbooks.Add()
Row = 1

for x in f:      #run this for every url in txt file.
 ie = IE_Invoke(x)
 starttime = time.clock()   #get timestamp at IE startup
 wait(ie)     #wait for IE to completetly load page
 stoptime = time.clock()    #get timestamp at IE completion
 elapsed = stoptime-starttime   #calculate the runtime
 ie.QUIT()
 xlApp.ActiveSheet.Cells(Row,1).Value = x
 xlApp.ActiveWorkbook.ActiveSheet.Cells(Row,2).Value = elapsed
 Row = Row+1

xlApp.ActiveWorkbook.ActiveSheet.SaveAs('c:\\test_results\dave.xls') #save results to excel book
xlApp.Quit() 
 

-- 
http://mail.python.org/mailman/listinfo/python-list