举例1
import win32com.client as win32
xl = win32.Dispatch('Excel.Application')
xl.Visible = True
xl.Workbooks.Add()
xlBook = xl.Workbooks(1)
xlSheet = xl.Sheets(1)
xlSheet.Cells(1,1).Value = 'What shall be the number of thy counting?'
xlSheet.Cells(2,1).Value = 3
print xlSheet.Cells(1,1).Value
print xlSheet.Cells(2,1).Value
举例2
#coding:utf-8
import win32com.client as win32
import time
import pythoncom
now = time.time()
print now
time_object = pythoncom.MakeTime(now)
print int(time_object)
xl = win32.Dispatch('Excel.Application')
xl.Visible = True
xl.Workbooks.Add()
xlBook = xl.Workbooks(1)
xlSheet = xl.Sheets(1)
xlSheet.Cells(1,1).Value = 'What shall be the number of thy counting?'
xlSheet.Cells(2,1).Value = 3
#print xlSheet.Cells(2,1).Value
xlSheet.Cells(3,1).Value = time_object
#print xlSheet.Cells(3,1).Value
xlSheet.Cells(4,1).Formula = '=A2*2'
#print xlSheet.Cells(4,1).Value
#print xlSheet.Cells(4,1).Formula
xlSheet.Cells(1,1).Value = None
#print xlSheet.Cells(1,1).Value
myRange1 = xlSheet.Cells(4,1) #一个单元格
myRange2 = xlSheet.Range("B5:C10") #
myRange3 = xlSheet.Range(xlSheet.Cells(2,2), xlSheet.Cells(3,8))
举例3
class easyExcel:
"""A utility to make it easier to get at Excel. Remebering to
save the data is your problem, as is error handling.
Operates on one workbook at a time."""
def __init__(self, filename=None):
self.xlApp = win32com.client.dispatch('Excel.Application')
if filename:
self.filename = filename
self.xlBook = self.xlApp.Workbooks.Open(filename)
else:
self.xlBook = self.xlApp.Workbooks.Add()
self.filename = ""
def sace(self, newfilename=None):
if newfilename:
self.filename = newfilename
self.xlBook.SaveAs(newfilename)
else:
self.xlBook.Save()
def close(self):
self.xlBook.Close(SaveChanges=0)
del self.xlApp
def getCell(self, sheet, row, col):
"Get value of one cell"
sht = self.xlBook.Worksheets(sheet)
return sht.Cells(row, col).value
def set(self, sheet, row, col, value):
"Set value of one cell"
sht = self.xlBook.Worksheets(sheet)
sht.Cells(row, col).Value = value
