python能对EXCEL文件操作吗?

jin_80

如:我有一个EXCEL文件,这个EXCEL文件里有SHEET1,SHEET2.我只想对SHEET1操作,SHEET2保势不变.请问用PYTHON如何操作??

asnama

1. from win32com.client import Dispatch
   
2. 
   
3. class easyExcel:
   
4.     """A utility to make it easier to get at Excel. Remembering
   
5.     to save the data is your problem, as is error handling.
   
6.     Operates on one workbook at a time."""
   
7. 
   
8.     def __init__(self, filename=None):
   
9.         self.xlApp = Dispatch('Excel.Application')
   
10.         if filename:
    
11.             self.filename = filename
    
12.             self.xlBook = self.xlApp.Workbooks.Open(filename)
    
13.         else:
    
14.             self.xlBook = self.xlApp.Workbooks.Add()
    
15.             self.filename = ''
    
16. 
    
17.     def save(self, newfilename=None):
    
18.         if newfilename:
    
19.             self.filename = newfilename
    
20.             self.xlBook.SaveAs(newfilename)
    
21.         else:
    
22.             self.xlBook.Save()
    
23. 
    
24.     def close(self):
    
25.         self.xlBook.Close(SaveChanges=0)
    
26.         del self.xlApp
    
27.         
    
28.     def getCell(self, sheet, row, col):
    
29.         "Get value of one cell"
    
30.         sht = self.xlBook.Worksheets(sheet)
    
31.         return sht.Cells(row, col).Value
    
32.    
    
33.     def getContiguousRange(self, sheet, row, col):
    
34.         """Tracks down and across from top left cell until it
    
35.         encounters blank cells; returns the non-blank range.
    
36.         Looks at first row and column; blanks at bottom or right
    
37.         are OK and return None within the array"""
    
38. 
    
39.         sht = self.xlBook.Worksheets(sheet)
    
40. 
    
41.         # find the bottom row
    
42.         bottom = row
    
43.         while sht.Cells(bottom + 1, col).Value not in [None, '']:
    
44.             bottom = bottom + 1
    
45. 
    
46.         # right column
    
47.         right = col
    
48.         while sht.Cells(row, right + 1).Value not in [None, '']:
    
49.             right = right + 1
    
50. 
    
51.         return sht.Range(sht.Cells(row, col), sht.Cells(bottom, right)).Value
    
52. 
    
53. if __name__ == '__main__':
    
54.     filename = r'list.xls'
    
55.     sheet = r'sheet1'
    
56.     staff = easyExcel(filename)
    
57. ##    print staff.getContiguousRange(sheet, 1,1)
    
58.     print staff.getCell(sheet, 1,1)
    
59.     staff.close()

复制代码

limodou

xlrd, pyexcelerator

分别看一下。

wangyue8018

对我很有帮助

riverbird2005

调用win32com模块．

sh_royan

学习了~~