Save Excel as HTML in Python

Question

I am trying to save an existing Excel file to HTML in Python using win32com.client. Below is my code and the resulting error message. Any suggestions?

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(r'D:\eclipse\test.xlsx')
excel.Visible = True
ws = wb.Worksheets('Sheet1')
ob = wb.PublishObjects.Add(1,'C:\test.html','Sheet1')
ob.Publish(True)

With the following Traceback:

Traceback (most recent call last):  
File "D:\eclipse\DMS\AGADMS\exceltohtml.py", line 21, in <module>  
ob = wb.PublishObjects.Add(1,'C:\test.html')  
File "C:\Python34\lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x7\PublishObjects.py", line 37, in Add
    , Title)  
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146827284), None)

import win32com.client as win32 excel = win32.gencache.EnsureDispatch('Excel.Application') wb = excel.Workbooks.Open(r'D:\eclipse\atest.xlsx') excel.Visible = True ws = wb.Worksheets('Sheet1') wb.PublishObjects.Add(SourceType=constants.xlSourceRange,Filename=r'D:\eclipse\atest1.html',Sheet='Sheet1',Source='$A$1:$F$6',HtmlType=constants.xlHtmlStatic, DivID='xxx1') wb.PublishObjects(1).Publish(True) — zhang jinxiang
– zhang jinxiang, Commented Oct 12, 2015 at 6:09

Brian Tompsett - 汤莱恩 · Accepted Answer · 2018-06-10 12:59:28Z

3

Pandas is very good for this.

Using pandas should simplify this for you. See below:

import pandas as pd 

wb = pd.read_excel('D:\eclipse\test.xlsx') # This reads in your excel doc as a pandas DataFrame

wb.to_html('C:\test.html') # Export the DataFrame (Excel doc) to an html file

Example Excel input:

Example html output:

Hope this helps.

edited Jun 10, 2018 at 12:59

Brian Tompsett - 汤莱恩

5,92772 gold badges63 silver badges135 bronze badges

answered Jun 10, 2018 at 12:26

Fletch

394 bronze badges

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

2 Comments

Pushan Gupta Over a year ago

But what about images stored in the excel

Shubham Sharma Over a year ago

This only saves dataframe. Not formatting and other info

venkat · Accepted Answer · 2020-05-13 20:34:49Z

0

Use xlsx2html module which will retain the cell formatting information as well. link:https://pypi.org/project/xlsx2html/

answered May 13, 2020 at 20:34

venkat

1713 silver badges15 bronze badges

Collectives™ on Stack Overflow

Save Excel as HTML in Python

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related