提取檔名字到excel表中

import os
import xlwt  # 操作excel模組
import sys

file_path = r'C:\Users\HP\Desktop\label-handwriting.xls'
f = xlwt.Workbook(encoding='utf-8', style_compression=0)  # 新建一個excel
sheet = f.add_sheet('sheet1')  # 新建一個sheet
pathDir = os.listdir(r'C:\Users\HP\Desktop\wang\SourceBmp')  # 獲取當前資料夾內所有檔案目錄

i = 0  # 將檔案列表寫入test.xls
for s in pathDir:
    s = s.split('.')[0]
    sheet.write(i, 0, s)  # 引數i,0,s分別代表行，列，寫入值
    i = i + 1

print(file_path)
print(i)  # 顯示檔名數量
f.save(file_path)