python操作树形的excel结构生成REC特定格式(包括生成父节点ID)

# -*- coding: utf-8 -*-
# 作者:东邪
import xlrd

last_line=['']*4
# 打开文件
try:
    data = xlrd.open_workbook("图书馆业务数据_三级导航.xls")
except:
    print("fail to open file")
else:
    # 文件读写方式是追加
    file = open("图书馆业务数据_三级导航.txt", "a")
    # 表头
    table = data.sheets()[0]
    # 行数
    row_cnt = table.nrows
    # 列数
    col_cnt = table.ncols
    # 第一行数据
    title = table.row_values(0)
    # 打印出行数列数
    print(row_cnt)
    # 打印列数
    print(col_cnt)
    # 打印名称
    print(title)
    row_data = []
    for j in range(1, row_cnt):
        row = table.row_values(j)

        #一级
        if row[2] != '':
            row[7] = str(int(row[0]))
            row[8] = 1
            row[9] = 1
            row[1] = 0
            last_line[0] = row[0]
            print(last_line)
            file.write('<REC>' + '\n')
            file.write('<ID>=' +