exporting html table to excel file which already have a format

Question

0.00/5 (No votes)

See more:

JavaScript

<script type="text/javascript">
        var tableToExcel = (function () {
            var uri = 'data:application/vnd.ms-excel;base64,'
                , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
                , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }
                , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
            return function (table, name) {
                if (!table.nodeType) table = document.getElementById(table)
                var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
                window.location.href = uri + base64(format(template, ctx))
            }
        })()
    </script>

using this code exproting html table to excel. My question is can i export html table to specified excel sheet template which i have already made.

Posted 15-Apr-15 1:39am

Muhamad Faizan Khan

Add a Solution

Comments

W∴ Balboos, GHB 15-Apr-15 7:48am

When I do such stuff I'll use php and an OBDC connection to the Excel driver (must be on same server as php). You can then handle the output much like SQL inserts. There are some restrictions (you can't delete a row, for example) but it can be a lot of fun.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

anil pathak · Answer 1 · 2015-04-15T04:42:00

Solution 1

Hi,

You can not export html table by javascript or jquery if you have browser IE8 or below version.

if you are using other browser and code not working then check then security issue.

Posted 15-Apr-15 4:42am

anil pathak

Updated 15-Apr-15 4:44am

v3

Comments

Muhamad Faizan Khan 16-Apr-15 0:34am

i am doing export. it working fine. Please read question carefully

anil pathak 16-Apr-15 2:32am

i read your question, but can you tried on IE 8 or below. because "data:application/vnd.ms-excel" is not supported by same browser

ok, let it be. if you are able export then can make a html template and replace your data by ajax call from server in template by loop in object in jquery or javascript.

And you can try what you doing..