返回顶部

收藏

Python 读取DBF文件,保存到Excel

更多

python读取dbf文件需要引用dbfpy模块,该模块是sourceforge上的开源项目

将dbf内容写入excel中用的是Windows的com组件,需要引用win32com模块。这也就是说下面这段程序只能在windows下运行。

[Python]代码

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,DBF,excel

收藏

0人收藏

支持

0

反对

0

发表评论