新手提问，如何用python操作excel

[Night]

因为需要写一个统计工具将数据集中到Excel中，所以学了python，但是又发现对Excel的com接口不了解，请问各位谁有好的文档说明excel com接口的，亦或者有相应的python操作excel测例子可以分享，小弟不胜感激，在此先行谢过

[iambic]

这个问题你在网上先搜索下吧，资料应该够了。我记得这个版面以前也贴过。不过是几年前了，最近几年没怎么关注。

[guzl86]

用pywin32了。
我前段时间刚刚做过这方面的东西，给你一段代码希望对你有所帮助。

from win32com.client import Dispatch
import win32com.client

class easyExcel:
      """A utility to make it easier to get at Excel.    Remembering
      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 save(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 GetExcelLineCount(self):
          count = 0
          sht = self.xlBook.Worksheets('第一轮')
          while True:
              if sht.Cells(count + 1, 1).Value == None:
                  break
              count += 1
          return count
      def getCell(self, sheet, row, col):
          "Get value of one cell"
          sht = self.xlBook.Worksheets(sheet)
          return sht.Cells(row, col).Value

      def setCell(self, sheet, row, col, value):
          "set value of one cell"
          sht = self.xlBook.Worksheets(sheet)
          sht.Cells(row, col).Value = value

      def getRange(self, sheet, row1, col1, row2, col2):
          "return a 2d array (i.e. tuple of tuples)"
          sht = self.xlBook.Worksheets(sheet)
          return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value

if __name__ == "__main__":
      xls = easyExcel('D:/用户目录/pythonworkspace/excel2doc/src/test.xls')
      lineNum = xls.GetExcelLineCount()
      for i in range(1,lineNum + 1):
          for j in range(1,8):
              print i,j,xls.getCell('第一轮', i, j)
      xls.save()
      xls.close()

[Night]

[Quote=引用 2 楼 insisted_search 的回复:]

用pywin32了。
我前段时间刚刚做过这方面的东西，给你一段代码希望对你有所帮助。
Python code
from win32com.client import Dispatch
import win32com.client

class easyExcel:
"""A utility to make it easier to get at Excel. Rememb……
[/Quote]
thx，这个对我帮助很大，谢谢

[li19800926]

如果电脑没装office，能运行吗？