1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| import os
import win32com.client as win32
def init_excel(print_file):
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(print_file)
ws = wb.Sheets('Sheet1')
ws.PrintOut()
wb.Close(False)
excel.Quit()
def excel_file():
path = os.getcwd()
files = os.listdir(path)
excelfiles = [f for f in files if not f.startswith(("~$")) and f.endswith((".xlsx"))]
for file in excelfiles:
fullpath = os.path.join(path,file)
print(fullpath)
init_excel(fullpath)
excel_file()
|