ansaurus

Question

Convert HTML to XLS from a webpage

Answer 1

A:

You can highlight any table and copy/paste it into Excel and Excel should handle the conversion nicely.

You can also provide .CSV versions of your reports.

ceejayoz 2009-12-28 15:58:13

Answer 2

+1 A:

You can grab that external page by using XHR, parse it's HTML and to return your data with content-type = "application/vnd.ms-excel"

Rubens Farias 2009-12-28 15:59:01

can you explain, i get the content-type, but what would be the process to take the data coming from the DB that is populated the datagrid, and create a download that has that corresponding data in an xls file.

sia 2009-12-28 16:11:12

Sorry, I thought that data are from a remote webserver; since you get database access, you just need to render a datagrid into a page and download it with appropriate content-type. Take a look here: http://www.c-sharpcorner.com/UploadFile/DipalChoksi/ExportASPNetDataGridToExcel11222005041447AM/ExportASPNetDataGridToExcel.aspx

Rubens Farias 2009-12-28 16:19:45

hahaha thanks for the link, i actually was looking at before i read your comment and saved the link....

sia 2009-12-28 16:42:52

Answer 3

A:

The easiest approach is to to just output a html table, and set the mime-type to application/vnd.ms-excel as @Rubens Farias said. If you have access to the existing application it's easy to extend, if not you must grab the html and parse it.

Excel can parse html tables without problems, even with formatting:

<html>
   <body>
      <table border="1">
         <tr>
            <td style="background-color: red">Content in cell</td>
            <td>Cell 2</td>
         </tr>
      </table>
   </body>
</html>

Mikael Svenson 2009-12-28 18:03:34

ansaurus

tags:

views:

answers:

Convert HTML to XLS from a webpage

related questions