angularjs - How to download Excel file using Angular js and REST Api -


angular js code:

$scope.getexceldownload = function(index,basketid,brokerid,tradedate,serverid,transid) {                 var myformid = 'excelform' + index;     exceldownload.get({brokerid : brokerid,basketname : basketid,appl : 'abc',param : 'excel',tradedate:tradedate,transactionid:transid,serverid:serverid},function(data, headers){         alert("success");          var response = {};         response.data = data;         response.headers = headers();           var blob = new blob([response.data], {type: "application/octet-stream;base64"});          var objecturl = url.createobjecturl(blob);             window.open(objecturl);             saveas(blob, "myfile.xls");     },function(errresponse) {         alert("failure");      });  }

rest webservice:

@requestmapping(value = "/getexcel/{brokerid}/{basketname}/{appl}/{param}/{tradedate}/{transactionid}/{serverid}", produces = { mediatype.application_octet_stream_value }, method = requestmethod.get)     public @responsebody responseentity<byte[]> getfile(@pathvariable("brokerid") string brokerid,@pathvariable("basketname") string basketname,@pathvariable("appl") string appl,@pathvariable("param") string param,@pathvariable("tradedate") string tradedate,@pathvariable("transactionid") string transactionid,@pathvariable("serverid") string serverid){         responseentity respentity = null;         ordersdownload orders = new ordersdownload();          if(param.equalsignorecase(excel_option)){             log.finest("exceldatacontroller@getfile selected option :" + param);             byte[] reportbytes = orderdownloadservice.doget(brokerid, basketname, appl, param, tradedate, transactionid, serverid);              httpheaders responseheaders = new httpheaders();             responseheaders.add("content-disposition", string.valueof(string                     .valueof((new stringbuffer("attachment; filename=\""))                             .append(                                     stringutils                                     .replace(basketname, ":", ""))                                     .append("_orders.xls\""))));             responseheaders.add("content-type",mediatype.application_octet_stream_value);              //return reportbytes;              respentity = new responseentity<byte[]>(reportbytes, responseheaders,httpstatus.ok);             return respentity;         }          return null;     }

response: file getting downloaded without contnet printing [object,object] inside file.

this work me

// download excel template file   $scope.downloadexceltemplate = function () {     customerservice.downloadtemplate().then(function (response) {       var linkelement = document.createelement('a');        try {          var filename = response.headers('content-name');         var blob = new blob([response.data], {type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});         var url = window.url.createobjecturl(blob);          linkelement.setattribute('href', url);         linkelement.setattribute("download", filename);          var clickevent = new mouseevent("click", {           "view": window,           "bubbles": true,           "cancelable": false         });         linkelement.dispatchevent(clickevent);       } catch (ex) {       }      }, function (response) {       toastr[messagetypes.error]('something went wrong.');       $scope.clearform();       $('#cl-modal-box').modal('hide');     });    }

this php function handles request

public function downloadtemplateaction() {          $customer = new customer();          $filename = 'customer_import_template.xlsx';         $uploaddir = $customer->getdownloadrootdir();         $filepath = $uploaddir . '/' . $filename;          // create phpexcel object read excel file         $objphpexcel = \phpexcel_iofactory::load($filepath);         // define writer object excel2007 || 2010         $objwriter = phpexcel_iofactory::createwriter($objphpexcel, "excel2007");          // set header params         header('content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8'); //        header('content-type: application/vnd.ms-excel; charset=utf-8');         header('content-disposition: attachment;filename=' . $filename);         header('cache-control: max-age=0');         header('content-name: ' . $filename);          $objwriter->save('php://output');         exit();     }

Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more