把excel中的元素按照一定顺序写到TXT文档中

Question

用python读取excel表中的特定表格数据，然后根据一定规则，写到TXT文档中。

vlan vpn-instance ipv4 ipv6
3560 GL_HA 1.1.168.137 255.255.255.252 2001:2001:952:2001:1::200/127
3580 GL_SC 1.1.182.137 255.255.255.252 2001:2001:953:2001:1::200/127

写出来的txt文档如下：
interface Eth-Trunk1.3560
vlan-type dot1q 3560
ip binding vpn-instance GL_HA
ipv6 enable
ip address 1.1.168.137 255.255.255.252
ipv6 address 2001:2001:952:2001:1::200/127
#
interface Eth-Trunk1.3580
vlan-type dot1q 3580
ip binding vpn-instance GL_SC
ipv6 enable
ip address 1.1.182.137 255.255.255.252
ipv6 address 2001:2001:953:2001:1::200/127

Answer 1

# 导入pandas库，用于读取和处理excel数据
import pandas as pd

# 定义excel文件的名称，可以根据实际情况修改
excel_file = "data.xlsx"

# 定义txt文件的名称，可以根据实际情况修改
txt_file = "result.txt"

# 读取excel文件中的数据，返回一个DataFrame对象
df = pd.read_excel(excel_file)

# 打开txt文件，准备写入数据
f = open(txt_file, "w")

# 遍历DataFrame对象的每一行数据
for index, row in df.iterrows():
    # 获取每一行数据的各个字段的值
    vlan = row["vlan"]
    vpn_instance = row["vpn-instance"]
    ipv4 = row["ipv4"]
    ipv6 = row["ipv6"]

    # 根据规则，生成要写入txt文件的字符串
    s = f"interface Eth-Trunk1.{vlan}\n"
    s += f"vlan-type dot1q {vlan}\n"
    s += f"ip binding vpn-instance {vpn_instance}\n"
    s += "ipv6 enable\n"
    s += f"ip address {ipv4}\n"
    s += f"ipv6 address {ipv6}\n"
    s += "#\n"

    # 将字符串写入txt文件
    f.write(s)

# 关闭txt文件
f.close()