I need export html table to excel with .xls extension in javascript or php
I am using below code but it does not export to file with .xls extension If possible in php code embedded in javascript code then its fine.
Link to fiddle.
var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html xmlns:o="urn:schemas-microsoft-:office:office"
xmlns:x="urn:schemas-microsoft-:office:excel" xmlns="">
<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))
}
});
I need export html table to excel with .xls extension in javascript or php
I am using below code but it does not export to file with .xls extension If possible in php code embedded in javascript code then its fine.
Link to fiddle.
var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html xmlns:o="urn:schemas-microsoft-:office:office"
xmlns:x="urn:schemas-microsoft-:office:excel" xmlns="http://www.w3/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))
}
});
- jsfiddle/insin/cmewv – Matrix123 Commented May 7, 2013 at 17:44
- @Matrix123 - could you edit that into the question, please? – andrewsi Commented May 7, 2013 at 17:46
- 3 @Matrix123 - sorry. I meant, could you add the code into your question, not the link. – andrewsi Commented May 7, 2013 at 17:48
- little known trick: if you simply save the html table markup in a file with an "xls" extension, it will open in excel and work as expected. both php and js can output HTML easily, so you're in luck. – dandavis Commented May 7, 2013 at 17:50
- @dandavis can u exaplain it in my given code/example – Matrix123 Commented May 7, 2013 at 17:58
2 Answers
Reset to default 1using a download lib from http://danml./js/download.js, it's easy.
function download(strData, strFileName, strMimeType) {
var D = document,
A = arguments,
a = D.createElement("a"),
d = A[0],
n = A[1],
t = A[2] || "text/plain";
//build download link:
a.href = "data:" + strMimeType + "," + escape(strData);
if (window.MSBlobBuilder) {
var bb = new MSBlobBuilder();
bb.append(strData);
return navigator.msSaveBlob(bb, strFileName);
} /* end if(window.MSBlobBuilder) */
if ('download' in a) {
a.setAttribute("download", n);
a.innerHTML = "downloading...";
D.body.appendChild(a);
setTimeout(function() {
var e = D.createEvent("MouseEvents");
e.initMouseEvent("click", true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
a.dispatchEvent(e);
D.body.removeChild(a);
}, 66);
return true;
} /* end if('download' in a) */
; //end if a[download]?
//do iframe dataURL download:
var f = D.createElement("iframe");
D.body.appendChild(f);
f.src = "data:" + (A[2] ? A[2] : "application/octet-stream") + (window.btoa ? ";base64" : "") + "," + (window.btoa ? window.btoa : escape)(strData);
setTimeout(function() {
D.body.removeChild(f);
}, 333);
return true;
} /* end download library function () */
// code that implements OP's functionality:
function tableToExcel (table) {
if (!table.nodeType) table = document.getElementById(table);
download(table.outerHTML, "table.xls", "application/vnd.ms-excel");
}
works in IE10, FF, and Chrome, maybe others as well.
In you Current File:
<?php
//Your Table code.
<a href="http://your_site_url./export_excel.php" target="_blank">
<input id="export-btn" type="button" value="Export as Excel" onclick="export()"/>
</a>
?>
Inside export_excel.php
<?php
$filename = 'Youe_Filename_without_extension';
header('Content-type: application/vnd.xls');
header('Content-Disposition: attachment; filename="'.$filename.'.xls"');
//Your Table code.
?>
Example Url: Demo
Update:
If you want it in the same file [to avoid duplication of the same code], then following code'll help:
<?php
$same_page = $_POST['same-page'];
if(!empty($same_page) && $same_page == 1) {
$filename = 'Sample Table';
header('Content-type: application/vnd.xls');
header('Content-Disposition: attachment; filename="'.$filename.'.xls"');
}?>
//Your Table code.
<?php if(empty($same_page)): ?>
//write whatever you want to hide in excel like export button,heading etc.
<form method="POST" action="" target="_balnk">
<input type="hidden" name="same-page" value="1"/>
<input id="export-btn" type="submit" value="Export as Excel on Form Submit"/>
</form>
<?php endif; ?>
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1745393763a4625783.html
评论列表（0条）