导出到excel时,html表的div样式不会出现excel [英] Div style of html table are not appearing excel when exported to excel
问题描述
<%@ Page Language =C#AutoEventWireup =trueCodeFile =Default.aspx.csInherits =_ Default%>
<!DOCTYPE html PUBLIC - // W3C // DTD XHTML 1.0 Transitional // ENhttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
< html id =Htm1xmlns =http://www.w3.org/1999/xhtml>
< head runat =server>
< title> Untitled Page< / title>
< script type =text / javascriptsrc =http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js>< / script>
< script type =text / javascript>
function exportToExcel(){
//将YourTable的innerHTML复制到strCopy变量。
调试器;
var strCopy = document.getElementById(anil) .outerHTML;
// clickExcel
//getElementById(\"Bdy1\").innerHTML;
//将strCopy复制到clipboardData,这个
window.clipboardData.setData(Text,strCopy);
var objExcel = new ActiveXObject(Excel.Application);
objExcel.visible = true;
var objWorkbook = objExcel.Workbooks.Add;
var objWorksheet = objWorkbook.Worksheets(1);
objWorksheet.Paste;
}
$ / b $ b
//
// var tableToExcel =(function(){
// var uri ='data:application / vnd.ms-excel; base64,'
//, template ='< html xmlns:o =urn:schemas-microsoft-com:office:officexmlns:x =urn:schemas-microsoft-com:office:excelxmlns =http://www.w3 .ORG / TR / REC-HTML40\" >< HEAD> <! - [if gte mso 9]>< xml>< x:excelworkbook xmlns:x =#unknown>< x:excelworksheets>< x:excelworksheet>< x:name> {工作表}< X:worksheetoptions>< X:displaygridlines>< / XML>< ENDIF] - GT;< /头><主体> {表}
//,base64 = function(s){return window.btoa(unescape(encodeURIComponent(s)))}
//,format = function(s,c){return s.replace(/ {(\w +)} / g,function(m,p){return c [p]; })
//返回函数(表,名称){
// if(!table.nodeType)table = document.getElementById(table)
// var ctx = {工作表:名称|| '工作表',表:table.innerHTML}
// window.location.href = uri + base64(格式(模板,ctx))
//}
//})()
函数clickExcel_onclick(){
}
< / script>
< style type =text / cssuserdata =Global>
body
{
font-size:12pt;
font-family:Calibri;
填充:10px;
}
表
{
border:1px纯黑色;
}
th
{
border:1px solid黑色;
填充:5px;
颜色:白色;
}
td
{
边框:1px纯黑色;
填充:5px;
}
div.menu1c {
border-color:#f00#f00#f0a35d#f00;
border:solid 2px;
身高:19px;
}
.content {
身高:75%;
宽度:50%;
border-color:栗色;
border-style:solid;
border-width:1px;
浮动:左;
}
div.example
{< br $>
margin-left:5px;
身高:100px;
宽度:100px;
边框:2px纯黑色;
}
输入
{
字体大小:12pt;
font-family:Calibri;
}
< /风格>
< / head>
< body>
< form id =form1 runat =server>
规则=groupsframe =hsidesborder =2>
代码页 ID | 名称 | ACP | OEMCP | Windows NT 3.1 | < th> Windows Windows 95 | |
---|---|---|---|---|---|---|
1200 | Unicode(ISO / IEC-10646的BMP) | X | X | * | ||
1250 | Windows 3.1东欧 | dewfrwerf sdwedf X | fdgdhg dewfrwerf sdwedf | fdgdhg dewfrwerf sdwedf | fdgdhg dewfrwerf sdwedf | X |
1251 | Windows 3.1西里尔语 | fdgdhg dewfrwerf sdwedf | fdgdhg dewfrwerf sdwedf | fdgdhg dewfrwerf sdwedf | fdgdhg dewfrwerf sdwedf | |
1252 | Windows 3.1美国(ANSI) | fdgdhg dewfrwerf sdwedf | X | X | X | |
1253 | Windows 3.1希腊语 | X | X | X | X | |
1254 | Windows 3.1土耳其语 | X | X | X | X | |
1255 | 希伯来语 | X | X | |||
1256 | 阿拉伯语 | X | < td> X | |||
1257 | Baltic | X | X | |||
1361 | 朝鲜语(Johab) | X | ** | X | ||
437 | MS-DOS美国 | X | X > | X | X | |
708 | 阿拉伯语(ASMO 708) | X | X | |||
709 | 阿拉伯语(ASMO 449 +,BCON V4) | X | X | |||
710 | 阿拉伯语(透明阿拉伯语) | X | X | |||
720 | 阿拉伯语(透明ASMO) | X | X |
< input id =clickExceltype =buttonstyle =height:35px; width:189pxvalue =BtnExportonclick =javascript:exportToExcel();önclick=返回clickExcel_onclick()/>
< / form>
< / body>
< / html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html id="Htm1" xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<script type="text/javascript" >
function exportToExcel() {
//copy innerHTML of YourTable to strCopy Variable.
debugger;
var strCopy = document.getElementById("anil").outerHTML;
// clickExcel
//getElementById("Bdy1").innerHTML;
//copy strCopy to clipboardData, this
window.clipboardData.setData("Text", strCopy);
var objExcel = new ActiveXObject("Excel.Application");
objExcel.visible = true;
var objWorkbook = objExcel.Workbooks.Add;
var objWorksheet = objWorkbook.Worksheets(1);
objWorksheet.Paste;
}
//
// 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 xmlns:x="#unknown"><x:excelworksheets><x:excelworksheet><x:name>{worksheet}<x:worksheetoptions><x:displaygridlines></xml><![endif]--></head><body>{table}
// , 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))
// }
//})()
function clickExcel_onclick() {
}
</script>
<style type="text/css" userdata="Global">
body
{
font-size: 12pt;
font-family: Calibri;
padding : 10px;
}
table
{
border: 1px solid black;
}
th
{
border: 1px solid black;
padding: 5px;
color: white;
}
td
{
border: 1px solid black;
padding: 5px;
}
div.menu1c {
border-color: #f00 #f00 #f0a35d #f00;
border: solid 2px;
height: 19px;
}
.content {
height:75%;
width:50%;
border-color:maroon;
border-style:solid;
border-width:1px;
float:left;
}
div.example
{
margin-left: 5px;
height: 100px;
width: 100px;
border: 2px solid black;
}
input
{
font-size: 12pt;
font-family: Calibri;
}
</style>
</head>
<body>
<form id="form1" runat="server">
rules="groups" frame="hsides" border="2">
Code-Page ID | Name | ACP | OEMCP | Windows NT 3.1 | Windows NT 3.51 | Windows 95 |
---|---|---|---|---|---|---|
1200 | Unicode (BMP of ISO/IEC-10646) | X | X | * | ||
1250 | Windows 3.1 Eastern European | dewfrwerf
sdwedf
X
| fdgdhg
dewfrwerf
sdwedf
| fdgdhg
dewfrwerf
sdwedf
| fdgdhg
dewfrwerf
sdwedf
| X |
1251 | Windows 3.1 Cyrillic | fdgdhg
dewfrwerf
sdwedf
| fdgdhg
dewfrwerf
sdwedf
| fdgdhg
dewfrwerf
sdwedf
| fdgdhg
dewfrwerf
sdwedf
| |
1252 | Windows 3.1 US (ANSI) | fdgdhg
dewfrwerf
sdwedf
| X | X | X | |
1253 | Windows 3.1 Greek | X | X | X | X | |
1254 | Windows 3.1 Turkish | X | X | X | X | |
1255 | Hebrew | X | X | |||
1256 | Arabic | X | X | |||
1257 | Baltic | X | X | |||
1361 | Korean (Johab) | X | ** | X | ||
437 | MS-DOS United States | X | X | X | X | |
708 | Arabic (ASMO 708) | X | X | |||
709 | Arabic (ASMO 449+, BCON V4) | X | X | |||
710 | Arabic (Transparent Arabic) | X | X | |||
720 | Arabic (Transparent ASMO) | X | X |
<input id="clickExcel" type="button" style="height:35px;width:189px" value="BtnExport" onclick="javascript:exportToExcel();" önclick="return clickExcel_onclick()" />
</form>
</body>
</html>
这篇关于导出到excel时,html表的div样式不会出现excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!