python自动遍历文件夹下simulink文件名并且输出到excel

​

# !/usr/bin/python
# -*- coding: UTF-8 -*-
import os
import xlsxwriter
file_number=0
i=0
mylist=[];
for root, dirs, files in os.walk(r"绝对路径", topdown=True):
for name in files:
if os.path.splitext(name)[1]=='.slx':
file_number +=1
mylist.append(name)

workbook=xlsxwriter.Workbook('test.xlsx')
worksheet=workbook.add_worksheet('sheet1')
for modle in mylist:
for j in range(len(mylist)):
worksheet.write(j,0,mylist[j])

workbook.close()