python excel html代码,在Python中将Excel另存为HTML

我正在尝试使用win32com.client将现有的Excel文件保存为

Python格式的HTML.下面是我的代码和生成的错误消息.有什么建议？

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)

使用以下Traceback：

Traceback (most recent call last):

File "D:\eclipse\DMS\AGADMS\exceltohtml.py", line 21, in

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)

最佳答案 熊猫对此非常好.

使用pandas应该为您简化这一点.见下文：

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

Excel输入示例：

示例html输出：

希望这可以帮助.