Python 读取DBF文件，保存到Excel，pythondbf,python读取dbf文

Python 读取DBF文件，保存到Excel，pythondbf,python读取dbf文

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

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

[Python]代码

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)