$scope.exportExcel = function(){if($scope.queryCallControl.starttime==""){ $scope.queryCallControl.starttime=null; } if($scope.queryCallControl.endtime==""){ $scope.queryCallControl.endtime=null; } return $http({ url: 'CallControlLogcontroller/getExport.do', method: "POST", headers: { 'Content-type': 'application/json' }, data:$scope.queryCallControl, responseType: 'arraybuffer' }).success(function (data) { // var blob = new Blob([data], {type: "application/vnd.openxmlformats-officedocument.sPReadsheetml.sheet"}); //使用{type: "application/vnd.ms-excel"}的寫法，可以保存為xls格式的excel文件（兼容老版本）。而使用“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”則會(huì)保存為xlsx var blob = new Blob([data], {type: "application/vnd.ms-excel"}); var time=$scope.CurentTime(); var filename="temp_" + time + ".xls"; if (window.navigator.msSaveOrOpenBlob) {// For IE: navigator.msSaveBlob(blob, filename); }else{ // For other browsers: var objectUrl = URL.createObjectURL(blob); var a = document.createElement('a'); document.body.appendChild(a); // var filename = data.headers('Content-Disposition').split(';')[1].trim().substr('filename='.length); console.log("filename:"+filename); a.setAttribute('style', 'display:none'); a.setAttribute('href', objectUrl); a.setAttribute('download', filename); a.click(); URL.revokeObjectURL(objectUrl); } });
1.post的方法里要加responseType: 'arraybuffer'參數(shù)，不然下載的excel會(huì)亂碼（這點(diǎn)一開始沒注意到，費(fèi)力好久）
2.使用{type: "application/vnd.ms-excel"}的寫法，可以保存為xls格式的excel文件（兼容老版本）。而使用“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”則會(huì)保存為xlsx
3.使用增加節(jié)點(diǎn)調(diào)用click方法，而不使用帖子中的window.open(objectUrl)方法，是防止被瀏覽器當(dāng)插件屏蔽彈出連接
參考：http://stackoverflow.com/questions/22447952/angularjs-http-post-convert-binary-to-excel-file-and-download
法二：
$http.post($rootScope.restful_api.last_output_excel,body_data,{responseType: 'arraybuffer'}).success(function(data){ var blob = new Blob([data], {type: "application/vnd.ms-excel"}); var objectUrl = URL.createObjectURL(blob); var aForExcel = $("<a><span class='forExcel'>下載excel</span></a>").attr("href",objectUrl); $("body").append(aForExcel); $(".forExcel").click(); aForExcel.remove(); })
