本文實例為大家分享了python操作EXCEL的實例源碼，供大家參考，具體內容如下

讀EXCEL的操作：把excel的數據存儲為字典類型

#coding=utf8  #導入讀excel的操作庫 import xlrd class GenExceptData(object):   def __init__(self):     try:       self.dataDic={}       #打開工作薄       self.wkbook= xlrd.open_workbook("Requirement.xls")       #獲取工作表“requirement”       self.dataSheet=self.wkbook.sheet_by_name("requirement")       #把數據按 按照相應格式寫入excel表中       self.readDataToDicl()       #保存文件     except Exception,e:       print "Read Excel error:",e     def readDataToDicl(self):     try:       nrows = self.dataSheet.nrows       ncols = self.dataSheet.ncols              print ncols ,nrows       try:         for rowNum in range(1,nrows):                   #把數據的當前行的元素與上一行元素作比較               #如果不相等執行if語句               try:                                  singleJson={}                 propertyName=self.dataSheet.cell(rowNum,3).value                 propertyValue=self.dataSheet.cell(rowNum,4).value                                              if self.dataSheet.cell(rowNum,0).value and self.dataSheet.cell(rowNum,2).value:                   mdEvent=self.dataSheet.cell(rowNum,0).value                   singleJson["serviceId"]=self.dataSheet.cell(rowNum,2).value                 singleJson[propertyName]=propertyValue                                print singleJson                 self.dataDic[mdEvent]=singleJson                 singleJson.clear()                                                 except Exception,e:                 print "Get Data Error:",e       except Exception,e:         print "Reading Data Error:",e     except Exception,e:       print "Reading Data TO Dic Error:",e                    def test():   GenExceptData()    if __name__=="__main__":   test() 

寫EXCEL的操作：把csv文件的數據按照需求寫入到excel文件中

#coding=utf8  from readCSV import readCSV import xlwt  class GenTestCase():   def __init__(self,path="E://PythonDemo//OperExcel//Demo.csv"):     self.dataInfor=readCSV(path)     #創建工作薄     self.wkbook=xlwt.Workbook()     #創建表:“埋點需求”     self.dataSheet=self.wkbook.add_sheet("shellt")     self.creatHead()        def creatHead(self):     firstLine=[]     #創建表頭     for index in range(len(firstLine)):       self.dataSheet.write(0,index,firstLine[index])            dataBody=self.dataInfor.buffer     print dataBody.__len__()     currentrow=1     for rowNum in range(1,len(dataBody)):       for index in range(len(dataBody[rowNum])):         if rowNum>1:           if dataBody[rowNum-1][0]!=dataBody[rowNum][0] :             print currentrow,rowNum             if currentrow==1:               for cols in range(3):                 cellValue=dataBody[currentrow][cols]                 cellValue=cellValue.decode("gbk")                 data=u"%s" %(cellValue)                 self.dataSheet.write_merge(currentrow,rowNum-1,cols,cols,data)                                for cols in range(6,13):                 cellValue=dataBody[currentrow][cols]                 cellValue=cellValue.decode("gbk")                 data=u"%s" %(cellValue)                 self.dataSheet.write_merge(currentrow,rowNum-1,cols,cols,data)                else:                 for cols in range(3):                 cellValue=dataBody[currentrow][cols]                 cellValue=cellValue.decode("gbk")                 data=u"%s" %(cellValue)                 self.dataSheet.write_merge(currentrow-1,rowNum-1,cols,cols,data)               for cols in range(6,12):                 cellValue=dataBody[currentrow][cols]                 cellValue=cellValue.decode("gbk")                 data=u"%s" %(cellValue)                 self.dataSheet.write_merge(currentrow-1,rowNum-1,cols,cols,data)                                   currentrow=rowNum+1                        break              for cols in range(3,6):                cellValue=dataBody[rowNum][cols]         cellValue=cellValue.decode("gbk")         data=u"%s" %(cellValue)         self.dataSheet.write(rowNum,cols,data)                      self.wkbook.save(r'reqq.xlsx')                   def test():   GenTestCase()    if __name__=="__main__":   test()