To convert an Excel file to PDF, simply operate Excel from win32com code example
Example: To convert an Excel file to PDF, simply operate Excel from win32com
import win32com.client
from pywintypes import com_error
WB_PATH = r'C:\hoge\fuga\YearCalendar.xlsx'
PATH_TO_PDF = r'C:\hoge\fuga\YearCalendar.pdf'
excel = win32com.client.Dispatch("Excel.Application")
excel.Visible = False
try:
print('Start conversion to PDF')
wb = excel.Workbooks.Open(WB_PATH)
ws_index_list = [1,2,3,4,5,6,7,8,9,10,11,12]
wb.WorkSheets(ws_index_list).Select()
wb.ActiveSheet.ExportAsFixedFormat(0, PATH_TO_PDF)
except com_error as e:
print('failed.')
else:
print('Succeeded.')
finally:
wb.Close()
excel.Quit()