- from win32com.client import constants, Dispatch
- class EasyExcel:
- def __init__(self, filename=None):
- self.xlApp = Dispatch('Excel.Application')
- if filename:
- self.filename = filename
- self.xlBook = self.xlApp.Workbooks.Open(filename)
- else:
- print "please input the filename"
- 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 getRange(self, sheet, row1, col1, row2, col2):
- "return a 2d array (i.e. tuple of tuples)"
- sht = self.xlApp.Worksheets(sheet)
- return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value
- #该片段来自于http://www.codesnippet.cn/detail/20112012489.html
来源: http://www.codesnippet.cn/detail/20112012489.html