<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>
