Example code for exporting Excel from HTML
This article explains in detail the example code of HTML exporting to Excel
<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">
<title>装修摊销报表</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<style>
.td_head{ text-align:center;
font-size:13pt;
font-weight:800;
font-family:宋体;
border:0.03cm;
background-color:silver;
}
.td_entry{ text-align:left;
font-size:10pt;
font-weight:200;
font-family:宋体;
border:thin;
}
.td_fraction{ text-align:right;
font-size:10pt;
font-weight:200;
font-family:宋体;
border:thin;
mso-number-format:"0.00";
}
</style>
<table border=1 id='tab1'>
<tr>
<td class="td_head" style="background-color:red;" >序号</td>
<td class="td_head" >机构名称</td>
<td class="td_head" >物业类型</td>
<td class="td_head" >物业名称</td>
<td class="td_head" >职场名称</td>
<td class="td_head" >合同编号</td>
<td class="td_head" >装修类型</td>
<td class="td_head" >合同金额</td>
<td class="td_head" >结算金额</td>
<td class="td_head" >租赁期</td>
<td class="td_head" >受益期</td>
<td class="td_head" >结算日</td>
<td class="td_head" >摊销期(月)</td>
<td class="td_head" >装修费总额<br>(A)</td>
<td class="td_head" >累计摊销金额<br>(B)</td>
<td class="td_head" >剩余摊销金额<br>(C=A-B)</td>
<td class="td_head" >本月摊销额<br>(D)</td>
<td class="td_head" >装修费总额<br>(财务结转后)<br>(E)</td>
<td class="td_head" >累计摊销金额<br>(财务结转后)<br>(F)</td>
<td class="td_head" >剩余摊销金额<br>(财务结转后)<br>(G=E-F)</td>
<td class="td_head" >本年累计摊销金额<br>(H)</td>
</tr>
<tr>
<td class="td_entry" colspan="2">小计</td>
<td class="td_entry" > 德城物业 </td>
<td class="td_entry" > 德城物业</td>
<td class="td_entry" > 德城物业</td>
<td class="td_entry" >LC010023130515</td>
<td class="td_entry" >1</td>
<td class="td_fraction" >6000<fmt:formatNumber value="${totalPactMoney}" pattern="##0.00" /></td>
<td class="td_fraction" >8000<fmt:formatNumber value="${totalFootMoney}" pattern="##0.00" /></td>
<td class="td_entry" >2015-6-9</td>
<td class="td_entry" >2015-6-6</td>
<td class="td_entry" >201506</td>
<td class="td_entry" >201507</td>
<td class="td_fraction" >88888<fmt:formatNumber value="${totalMoney}" pattern="##0.00" /></td>
<td class="td_fraction" >6052<fmt:formatNumber value="${totalAmortizedMoney}" pattern="##0.00" /></td>
<td class="td_fraction" >5555<fmt:formatNumber value="${totalRemainingAmortizedMoney}" pattern="##0.00" /></td>
<td class="td_fraction" >62<fmt:formatNumber value="${totalQueryMonthMoney}" pattern="##0.00" /></td>
<td class="td_fraction" >55<fmt:formatNumber value="${totalMoneyEnd}" pattern="##0.00" /></td>
<td class="td_fraction" >55<fmt:formatNumber value="${totalAmortizedMoneyEnd}" pattern="##0.00" /></td>
<td class="td_fraction" >112<fmt:formatNumber value="${totalRemainingAmortizedMoneyEnd}" pattern="##0.00" /></td>
<td class="td_fraction" >2015<fmt:formatNumber value="${totalyearAmortizatedMoneyEnd}" pattern="##0.00" /></td>
</tr>
</table>
<script type="text/javascript">
//第五种方法
var idTmr;
function getExplorer() {
var explorer = window.navigator.userAgent ;
//ie
if (explorer.indexOf("MSIE") >= 0) {
return 'ie';
}
//firefox
else if (explorer.indexOf("Firefox") >= 0) {
return 'Firefox';
}
//Chrome
else if(explorer.indexOf("Chrome") >= 0){
return 'Chrome';
}
//Opera
else if(explorer.indexOf("Opera") >= 0){
return 'Opera';
}
//Safari
else if(explorer.indexOf("Safari") >= 0){
return 'Safari';
}
}
function method5(tableid) {
if(getExplorer()=='ie')
{
var curTbl = document.getElementById(tableid);
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var xlsheet = oWB.Worksheets(1);
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
sel.select();
sel.execCommand("Copy");
xlsheet.Paste();
oXL.Visible = true;
try {
var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
} catch (e) {
print("Nested catch caught " + e);
} finally {
oWB.SaveAs(fname);
oWB.Close(savechanges = false);
oXL.Quit();
oXL = null;
idTmr = window.setInterval("Cleanup();", 1);
}
}
else
{
tableToExcel(tableid)
}
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html><head><meta charset="UTF-8"></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))
}
})()
window.onload=function(){
tableToExcel("tab1");
}
</script>The above is the detailed content of Example code for exporting Excel from HTML. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Is HTML easy to learn for beginners?
Apr 07, 2025 am 12:11 AM
HTML is suitable for beginners because it is simple and easy to learn and can quickly see results. 1) The learning curve of HTML is smooth and easy to get started. 2) Just master the basic tags to start creating web pages. 3) High flexibility and can be used in combination with CSS and JavaScript. 4) Rich learning resources and modern tools support the learning process.
The Roles of HTML, CSS, and JavaScript: Core Responsibilities
Apr 08, 2025 pm 07:05 PM
HTML defines the web structure, CSS is responsible for style and layout, and JavaScript gives dynamic interaction. The three perform their duties in web development and jointly build a colorful website.
Understanding HTML, CSS, and JavaScript: A Beginner's Guide
Apr 12, 2025 am 12:02 AM
WebdevelopmentreliesonHTML,CSS,andJavaScript:1)HTMLstructurescontent,2)CSSstylesit,and3)JavaScriptaddsinteractivity,formingthebasisofmodernwebexperiences.
Gitee Pages static website deployment failed: How to troubleshoot and resolve single file 404 errors?
Apr 04, 2025 pm 11:54 PM
GiteePages static website deployment failed: 404 error troubleshooting and resolution when using Gitee...
What is an example of a starting tag in HTML?
Apr 06, 2025 am 12:04 AM
AnexampleofastartingtaginHTMLis,whichbeginsaparagraph.StartingtagsareessentialinHTMLastheyinitiateelements,definetheirtypes,andarecrucialforstructuringwebpagesandconstructingtheDOM.
How to use CSS3 and JavaScript to achieve the effect of scattering and enlarging the surrounding pictures after clicking?
Apr 05, 2025 am 06:15 AM
To achieve the effect of scattering and enlarging the surrounding images after clicking on the image, many web designs need to achieve an interactive effect: click on a certain image to make the surrounding...
HTML, CSS, and JavaScript: Essential Tools for Web Developers
Apr 09, 2025 am 12:12 AM
HTML, CSS and JavaScript are the three pillars of web development. 1. HTML defines the web page structure and uses tags such as, etc. 2. CSS controls the web page style, using selectors and attributes such as color, font-size, etc. 3. JavaScript realizes dynamic effects and interaction, through event monitoring and DOM operations.
How to implement adaptive layout of Y-axis position in web annotation?
Apr 04, 2025 pm 11:30 PM
The Y-axis position adaptive algorithm for web annotation function This article will explore how to implement annotation functions similar to Word documents, especially how to deal with the interval between annotations...
