Example code for exporting Excel from HTML-HTML Tutorial-php.cn

Home

Web Front-end

HTML Tutorial

Example code for exporting Excel from HTML

高洛峰

Mar 24, 2017 am 11:50 AM

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=&#39;tab1&#39;>
		<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 &#39;ie&#39;;  
            }  
            //firefox  
            else if (explorer.indexOf("Firefox") >= 0) {  
                return &#39;Firefox&#39;;  
            }  
            //Chrome  
            else if(explorer.indexOf("Chrome") >= 0){  
                return &#39;Chrome&#39;;  
            }  
            //Opera  
            else if(explorer.indexOf("Opera") >= 0){  
                return &#39;Opera&#39;;  
            }  
            //Safari  
            else if(explorer.indexOf("Safari") >= 0){  
                return &#39;Safari&#39;;  
            }  
        }  
        function method5(tableid) {  
            if(getExplorer()==&#39;ie&#39;)  
            {  
                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 = &#39;data:application/vnd.ms-excel;base64,&#39;,  
                    template = &#39;<html><head><meta charset="UTF-8"></head><body><table>{table}</table></body></html>&#39;,  
                    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 || &#39;Worksheet&#39;, table: table.innerHTML}  
                window.location.href = uri + base64(format(template, ctx))  
            }  
        })()  


		window.onload=function(){
			tableToExcel("tab1");
		}
	</script>

Copy after login

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!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

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

How to fix KB5055523 fails to install in Windows 11?

3 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks ago By DDD

Roblox: Dead Rails - How To Tame Wolves

1 months ago By DDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Grow A Garden - Complete Mutation Guide

2 weeks ago By DDD

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

Java Tutorial

1662

CakePHP Tutorial

1418

Laravel Tutorial

1311

PHP Tutorial

1261

C# Tutorial

1234

Related knowledge

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.

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.

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.

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.

HTML: The Structure, CSS: The Style, JavaScript: The Behavior Apr 18, 2025 am 12:09 AM

The roles of HTML, CSS and JavaScript in web development are: 1. HTML defines the web page structure, 2. CSS controls the web page style, and 3. JavaScript adds dynamic behavior. Together, they build the framework, aesthetics and interactivity of modern websites.

The Future of HTML: Evolution and Trends in Web Design Apr 17, 2025 am 12:12 AM

The future of HTML is full of infinite possibilities. 1) New features and standards will include more semantic tags and the popularity of WebComponents. 2) The web design trend will continue to develop towards responsive and accessible design. 3) Performance optimization will improve the user experience through responsive image loading and lazy loading technologies.

HTML vs. CSS vs. JavaScript: A Comparative Overview Apr 16, 2025 am 12:04 AM

The roles of HTML, CSS and JavaScript in web development are: HTML is responsible for content structure, CSS is responsible for style, and JavaScript is responsible for dynamic behavior. 1. HTML defines the web page structure and content through tags to ensure semantics. 2. CSS controls the web page style through selectors and attributes to make it beautiful and easy to read. 3. JavaScript controls web page behavior through scripts to achieve dynamic and interactive functions.

The Future of HTML, CSS, and JavaScript: Web Development Trends Apr 19, 2025 am 12:02 AM

The future trends of HTML are semantics and web components, the future trends of CSS are CSS-in-JS and CSSHoudini, and the future trends of JavaScript are WebAssembly and Serverless. 1. HTML semantics improve accessibility and SEO effects, and Web components improve development efficiency, but attention should be paid to browser compatibility. 2. CSS-in-JS enhances style management flexibility but may increase file size. CSSHoudini allows direct operation of CSS rendering. 3.WebAssembly optimizes browser application performance but has a steep learning curve, and Serverless simplifies development but requires optimization of cold start problems.

See all articles