saving an existing worksheet as html in python

Question

I went through these link and other links for xlwt, xlrd and xlutils writing to existing workbook using xlwt

from xlutils.copy import copy    
from xlrd import open_workbook    
from xlwt import easyxf    
rb = open_workbook('example.xls',formatting_info=True)    
r_sheet = rb.sheet_by_index(0)    
print r_sheet    
print r_sheet.name    
wb = copy(rb)    
w_sheet = wb.get_sheet(0)    
print w_sheet.name    
w_sheet.save('example.html')    #it throws an error in the last line saying "AttributeError: 'Worksheet' object has no attribute 'save'"

How can I save the worksheet alone as HTML file uing python

You are trying to use an xlrd Book class instance to save. From the xlrd description in the docs: This package is for reading data and formatting information from Excel files.. The Book class does NOT have a save method. — wwii
– wwii, Commented Oct 27, 2013 at 17:18

joaquin · Accepted Answer · 2013-10-27 16:25:00Z

1

I am not sure you can save and excel sheet as html just with xlwt or xlrd.

One alternative is to use pandas which internally uses xlrd and xlwt saving you of coding all the steps involved.

You can read your excel sheet with

df = pandas.read_excel('example.xls', sheetname='sheet1')

and get it as html with:

html = df.to_html()

html is a string you can save in a file with open(myfile, 'w').write(html)

answered Oct 27, 2013 at 16:25

joaquin

86k31 gold badges146 silver badges155 bronze badges

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

Collectives™ on Stack Overflow

saving an existing worksheet as html in python

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