031 解析工作簿的路径信息
from pathlib import Path
file_path = Path(r'D:\python_file\receiving.xlsx')
path = file_path.parent # 提取工作簿所在文件夹的路径
file_name = file_path.name # 提取工作簿的文件名
stem_name = file_path.stem # 提取工作簿的文件主名
suf_name = file_path.suffix # 提取工作簿的扩展名
print(path)
print(file_name)
print(stem_name)
print(suf_name)
C:\Users\jjshe\anaconda3\python.exe “D:/Python/150例/031 解析工作簿的路径信息.py”
D:\python_file
receiving.xlsx
receiving
.xlsx
Process finished with exit code 0