Python导出DBF文件到Excel的方法

本文实例讲述了python/' target='_blank'>python导出DBF文件到Excel的方法。分享给大家供大家参考。具体如下：

from dbfpy import dbffrom time import sleepfrom win32com import clientdef dbf2xls(dbfilename, exfilename):  db = dbf.Dbf(dbfilename, True)  ex = client.Dispatch('Excel.Application')  wk = ex.Workbooks.Add()  ws = wk.ActiveSheet  ex.Visible = True  sleep(1)  r = 1  c = 1  for field in db.fieldNames:    ws.Cells(r,c).Value = field    c = c+1  r = 2  for record in db:    c = 1    for field in db.fieldNames:      ws.Cells(r,c).Value = record[field]      c = c+1    r = r+1  wk.SaveAs(exfilename)  wk.Close(False)  ex.Application.Quit()  db.close()if __name__=='__main__':  dbffilename = "test.dbf"  xlsfilename = "text.xls"  dbf2xls(dbffilename, xlsfilename)

希望本文所述对大家的Python程序设计有所帮助。