problem :python Batch opening required excel file
Code :
import os
import xlwings as xw
app = xw.App(visible = True,add_book = False)
path =' Folder '
for file in os.listdir(path):
if file.endswith('.xlsx'):
app.books.open(file)
Operation results and error reporting contents :
FileNotFoundError: No such file:‘xxx.xlsx’
My solution ideas and tried methods :
1.path Change to specific file name
2. Change the name of the Chinese document to English
What I want to achieve :
Open in bulk excel