js导出excel
来源:互联网 发布:编程开发培训机构 编辑:程序博客网 时间:2024/06/12 02:42
<td style="vnd.ms-excel.numberformat:@;"><s:property value="accountCode" /></td>
//1)文本:vnd.ms-excel.numberformat:@
//2)日期:vnd.ms-excel.numberformat:yyyy/mm/dd
//3)数字:vnd.ms-excel.numberformat:#,##0.00
//4)货币:vnd.ms-excel.numberformat:¥#,##0.00
//5)百分比:vnd.ms-excel.numberformat: #0.00%
<fmt:formatNumber value="${(money / lastMoney - 1) * 100 }" pattern="#.##%" minFractionDigits="2" />
<fmt:formatNumber value="${n_balance}" pattern="#.##" minFractionDigits="2"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#wwo').click(function(){ //, {"value":"日期", "type":"ROW_HEADER_HEADER", "datatype":"string"}
var data = {"title":[{"value":"集团", "type":"ROW_HEADER_HEADER", "datatype":"string"}],"data":[[{"value":"好好", "type":"ROW_HEADER"}, {"value":"08/24", "type":"ROW_HEADER","datatype":"string"}]]};
if(data == '')
return;
JSONToExcelConvertor(data.data, "Report", data.title);
});
});
function JSONToExcelConvertor(JSONData, FileName, ShowLabel) {
//先转化json
var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
var excel = '<table>';
excel += '<tr><td colspan="2">集团</td></tr>';
excel += '<tr><td style="vnd.ms-excel.numberformat:@;">08/24</td><td style="vnd.ms-excel.numberformat:@;">好好</td></tr>' ;
//设置表头
//var row = "<tr>";
//for (var i = 0, l = ShowLabel.length; i < l; i++) {
// row += "<td colspan='2'>" + ShowLabel[i].value + '</td>';
//}
//换行
//excel += row + "</tr>";
//设置数据
//for (var i = 0; i < arrData.length; i++) {
// var row = "<tr>";
// for (var index in arrData[i]) {
// var value = arrData[i][index].value === "." ? "" : arrData[i][index].value;
// row += '<td style="vnd.ms-excel.numberformat:@;">' + value + '</td>';
// }
// excel += row + "</tr>";
//}
excel += "</table>";
var excelFile = "<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'>";
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
excelFile += '; charset=UTF-8">';
excelFile += "<head>";
excelFile += "<!--[if gte mso 9]>";
excelFile += "<xml>";
excelFile += "<x:ExcelWorkbook>";
excelFile += "<x:ExcelWorksheets>";
excelFile += "<x:ExcelWorksheet>";
excelFile += "<x:Name>";
excelFile += "{worksheet}";
excelFile += "</x:Name>";
excelFile += "<x:WorksheetOptions>";
excelFile += "<x:DisplayGridlines/>";
excelFile += "</x:WorksheetOptions>";
excelFile += "</x:ExcelWorksheet>";
excelFile += "</x:ExcelWorksheets>";
excelFile += "</x:ExcelWorkbook>";
excelFile += "</xml>";
excelFile += "<![endif]-->";
excelFile += "</head>";
excelFile += "<body>";
excelFile += excel;
excelFile += "</body>";
excelFile += "</html>";
var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
var link = document.createElement("a");
link.href = uri;
link.download = FileName + ".xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
</script>
</head>
<body>
<input type="button" id="wwo" value="导出" />
</body>
</html>
- js导出EXCEL js导出EXCEL
- JS导出datagrid导出Excel
- JS导出EXCEL
- js导出到excel
- js导出Excel
- js导入导出excel
- js导出Excel
- js 导出 excel
- js 导出Excel
- JS导出Excel/word
- JS 导出EXCEL
- js导出Excel
- JS导出Excel
- Js导出Excel
- js操作Excel导出
- JS导出 excel
- js导出成excel
- JS导出Excel
- android wifi讲解 wifi列表显示
- javascript写在<head>和<body>里的区别
- 1.18.ARM汇编指令集6之跳转指令
- 浅析HTML5的10大优势
- C库头文件(C99)
- js导出excel
- 图像各种变换 Miscellaneous Image Transformations
- HTML5中meta属性的应用
- bzoj3295树状数组套主席树
- Unity3D默认的快捷键
- 分布式配置管理平台disconf-初体验
- 基于Python检索系统(1)总体介绍
- Play framework自定义标签
- HDU6047Maximum Sequence