CODEWITHSUNDEEP
pythondjangoexcelhtml-table
kafuchau
kafuchau

Reputation: 5593

Django/Python: Save an HTML table to Excel

I have an HTML table that I'd like to be able to export to an Excel file. I already have an option to export the table into an IQY file, but I'd prefer something that didn't allow the user to refresh the data via Excel. I just want a feature that takes a snapshot of the table at the time the user clicks the link/button.

I'd prefer it if the feature was a link/button on the HTML page that allows the user to save the query results displayed in the table. It would also be nice if the formatting from the HTML/CSS could be retained. Is there a way to do this at all? Or, something I can modify with the IQY?

I can try to provide more details if needed. Thanks in advance.

Upvotes: 5

Views: 10946

Answers (3)

Clément
Clément

Reputation: 6748

Excel support opening an HTML file containing a table as a spreadsheet (even with CSS formatting).

You basically have to serve that HTML content from a django view, with the content-type application/ms-excel as Roberto said.

Or if you feel adventurous, you could use something like Downloadify to prepare the file to be downloaded on the client side.

Upvotes: 0

rob
rob

Reputation: 37644

You can use the excellent xlwt module. It is very easy to use, and creates files in xls format (Excel 2003).

Here is an (untested!) example of use for a Django view:

from django.http import HttpResponse
import xlwt

def excel_view(request):
  normal_style = xlwt.easyxf("""
     font:
         name Verdana
     """) 
  response = HttpResponse(mimetype='application/ms-excel')
  wb = xlwt.Workbook()
  ws0 = wb.add_sheet('Worksheet')
  ws0.write(0, 0, "something", normal_style)
  wb.save(response)
  return response

Upvotes: 7

moshez
moshez

Reputation: 37517

Use CSV. There's a module in Python ("csv") to generate it, and excel can read it natively.

Upvotes: 2

Related Questions