import xlsxwriter
def make_excel(file_name, excel_data):
workbook = xlsxwriter.Workbook(file_name)
worksheet = workbook.add_worksheet("Sheet1")
set_worksheet = workbook.get_worksheet_by_name("Sheet1")
set_worksheet.set_column("A:G", 20)
for index in range(len(excel_data)):
worksheet.write_row(index, 0, excel_data[index])
workbook.close()
if __name__ == '__main__':
excel_data = [
["IP地址", "MAC地址", "接口", "设备管理IP"],
["192.168.1.1", "B7:E3:B1:58:92:B1", "MEth0/0/1", "172.27.55.22"],
["192.168.1.2", "B8:E3:B1:58:92:B2", "MEth0/0/2", "172.27.55.23"],
["192.168.1.3", "B9:E3:B1:58:92:B3", "MEth0/0/1", "172.27.55.24"]
]
file_name = r"E:\My_Work\TEST\test.xlsx"
make_excel(file_name, excel_data)
标签：__,name,excel,xlsxwriter,写入,file,worksheet,data From： https://www.cnblogs.com/zhangguosheng1121/p/16758298.html