python - 有没有办法用（SW1 + 当前时间和日期）命名工作表名称？我得到了我想要的名称的 xlsx 文件

Question

我正在尝试获得sheet_name第一行代码，但我似乎无法弄清楚。这可能吗，有没有人有任何想法如何让它发挥作用？

Sheetname = 'Int_Stat_' + time.strftime("%m_%d_%Y_%I%M_%p") +'.xlsx'
# First create a Pandas Excel Writer "object"
writer = pd.ExcelWriter(Sheetname, engine='openpyxl')
net_connect = ConnectHandler(**SW1)
int_stat =  net_connect.send_command("show int status", use_textfsm=True)
print(int_stat)
print(len(int_stat))
for line in int_stat:
    print(json.dumps(line, indent=8))
int_data = {'PORT': [entry['port'] for entry in int_stat],
             'NAME': [entry['name'] for entry in int_stat],
             'STATUS': [entry['status'] for entry in int_stat],
             'VLAN': [entry['vlan'] for entry in int_stat],
             'DUPLEX': [entry['duplex']for entry in int_stat],
             'SPEED': [entry['speed'] for entry in int_stat],
             'TYPE': [entry['type'] for entry in int_stat],
             'FC_MODE': [entry['fc_mode'] for entry in int_stat],
            }     
df = pd.DataFrame(int_data, columns=list(int_data.keys()))
print(df.head())

df.to_excel(writer, sheet_name='SW1')
writer.save()

标签： pythonpandasopenpyxl