Python导出DBF文件到Excel的方法

本文实例讲述了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程序设计有所帮助。

以上是 Python导出DBF文件到Excel的方法 的全部内容, 来源链接: utcz.com/z/315131.html

回到顶部