引言：以前寫(xiě)的一個(gè)批量xls轉(zhuǎn)csv的python簡(jiǎn)單腳本，用的是python2.7

#coding=utf-8import osimport timeimport loggingimport xlrdimport csv #xls文件存放路徑INPUTPATH= u"D://lsssl//桌面//xls文件" #生成的csv文件存放路徑OUTPATH = u"D://lsssl/桌面//csv"  class changeCenter: def __init__(self):  pass def getvalue(self,filename):  self.mData = []  xlsfile=xlrd.open_workbook(filename)  table = xlsfile.sheet_by_index(0)#sheet1  rownum = table.nrows #行  colsnum = table.ncols #列  for i in range(0,rownum):   row = []   for j in range(0,colsnum):    value = table.cell_value(i,j)    if not isinstance(value,float):     value = value.encode('gbk')#非數(shù)字轉(zhuǎn)一下碼    row.append(value)   self.mData.append(tuple(row)) def write(self, path, filename):  if not os.path.exists(path):   os.makedirs(path)  csvfile = file("tmp","wb")  writer = csv.writer(csvfile)  writer.writerows(self.mData)  csvfile.close()    if os.path.exists(os.path.join(path,filename+".old")):   os.remove(os.path.join(path,filename+".old"))  if os.path.exists(os.path.join(path,filename)):   os.rename(os.path.join(path,filename),os.path.join(path,filename+".old"))  os.rename('tmp', os.path.join(path,filename))  logging.info("write file finish")  print "write",filename," finish"  def handleExcel(): files,dirs,root = readFilename(INPUTPATH) for fi in files:  strstock = os.path.join(INPUTPATH,fi)  if os.path.exists(strstock):   st = changeCenter()   st.getvalue(strstock)   name = fi.replace(".xls","")   st.write(OUTPATH, name+".csv")  else:   print strstock+" don't exist" #獲取某個(gè)路徑下的所有文件 def readFilename(file_dir): for root, dirs, files in os.walk(file_dir):   return files,dirs,root if __name__ == '__main__': handleExcel()

以上這篇python 實(shí)現(xiàn)批量xls文件轉(zhuǎn)csv文件的方法就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持武林站長(zhǎng)站。