import os
import xlwings as xw
def excel2pdf(file):
app = xw.App(visible=True,add_book=False)
wb = app.books.open(file)
sht = wb.sheets[0]
current_work_dir = os.getcwd()
pdffile= file.strip('xls')+'pdf'
pdf_path = os.path.join(current_work_dir, pdffile)
sht.api.ExportAsFixedFormat(0, pdf_path)
filelist = os.listdir('./')
for file in filelist:
excel2pdf(file)
