python 操作dbf文件：dbf模块

little_kid_pea

于 2024-08-14 17:19:59 发布

阅读量175

点赞数 3

文章标签： python 前端 linux dbf

本文链接：https://blog.csdn.net/little_kid_pea/article/details/141195659

版权

import dbf

filename = "test.dbf"

with dbf.Table(filename) as tb:
    tb.open(dbf.READ_WRITE)
    for row in dbf.Process(tb):
        if row['MZ'].strip() == '57':
            row.MZ = '99'

open需要指定读写模式，默认只读，若需要修改数据，open需要指定dbf.READ_WRITE

修改数据需要使用Process或者with：

for row in dbf.Process(tb):
    if row['MZ'].strip() == '57':
        row.MZ = '99'

for row in tb:
    if row['MZ'].strip() == '57':
        with row:
            row.MZ = '99'

复制a.dbf的表头，到另一个新建的文件b.dbf中

srcfile = "a.dbf"
dstfile = "b.dbf"

with dbf.Table(srcfile) as src:

    src.open()

    dst = src.new(dstfile)

    dst.open()

    # do something

    dst.close()