<SCRIPT LANGUAGE="JavaScript">
<!--
function getStyle(){
var Style='<style>TB{BACKGROUND-COLOR: black;FONT-SIZE: 12px;LINE-HEIGHT: 16px;TEXT-DECORATION: none;} td{mso-number-format:"\@";BACKGROUND-COLOR:white} td.top{BACKGROUND-COLOR: #4F93DC;COLOR: #ffffff;FONT-SIZE: 12px; LINE-HEIGHT: 16px; TEXT-DECORATION: none;}</style>';
return Style;
}
function FunSave(strContent) //
{
var strOut=getStyle()+strContent;
var winSave = window.open(); winSave.document.open ("text/html","gb2312"); winSave.document.write (strOut); winSave.document.execCommand ("SaveAs",true,"报表.xls"); winSave.close();
}
//-->
</SCRIPT>上面的语句,
1.导出EXCEL为什么不能应用定义的样式表
2.为什么导出的表格中数字都变成了文本型的?如何修改
<!--
function getStyle(){
var Style='<style>TB{BACKGROUND-COLOR: black;FONT-SIZE: 12px;LINE-HEIGHT: 16px;TEXT-DECORATION: none;} td{mso-number-format:"\@";BACKGROUND-COLOR:white} td.top{BACKGROUND-COLOR: #4F93DC;COLOR: #ffffff;FONT-SIZE: 12px; LINE-HEIGHT: 16px; TEXT-DECORATION: none;}</style>';
return Style;
}
function FunSave(strContent) //
{
var strOut=getStyle()+strContent;
var winSave = window.open(); winSave.document.open ("text/html","gb2312"); winSave.document.write (strOut); winSave.document.execCommand ("SaveAs",true,"报表.xls"); winSave.close();
}
//-->
</SCRIPT>上面的语句,
1.导出EXCEL为什么不能应用定义的样式表
2.为什么导出的表格中数字都变成了文本型的?如何修改
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货