Using Python convert excel sheet to different format

Question

I have an Excel file. I want to automatically open it and save it in HTML format. The below code is not working as internded. The converted HTML is not readable Kindly let me know how this can be done.


import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
excel.Visible = True
wb = excel.Workbooks.Open(r"Report.xlsx")
wb.Saveas("Report.html")
wb.Close()
excel.Quit()

Dini · Accepted Answer · 2022-10-07 14:08:07Z

1

You could use pandas to open the Excel file and then pandas will export to HTML and other formats.

answered Oct 7, 2022 at 14:08

Dini

1674 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Python convert excel sheet to different format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related