当前位置:Gxlcms > Python > Python导出DBF文件到Excel的方法

Python导出DBF文件到Excel的方法

时间:2021-07-01 10:21:17 帮助过:57人阅读

本文实例讲述了Python导出DBF文件到Excel的方法。分享给大家供大家参考。具体如下:

from dbfpy import dbf
from time import sleep
from win32com import client
def 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程序设计有所帮助。

人气教程排行