AngularJS $http-post – convert binary to excel file and download

by

Just noticed you can’t use it because of IE8/9 but I’ll push submit anyway… maybe someone finds it useful

This can actually be done through the browser, using blob. Notice the responseType and the code in the success promise.

$http({
    url: 'your/webservice',
    method: "POST",
    data: json, //this is your json data string
    headers: {
       'Content-type': 'application/json'
    },
    responseType: 'arraybuffer'
}).success(function (data, status, headers, config) {
    var blob = new Blob([data], {type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});
    var objectUrl = URL.createObjectURL(blob);
    window.open(objectUrl);
}).error(function (data, status, headers, config) {
    //upload failed
});

There are some problems with it though like:

  1. It doesn’t support IE 8 and 9:
  2. It opens a pop up window to open the objectUrl which people might have blocked
  3. Generates weird filenames

It did work!

blob
The server side code in PHP I tested this with looks like this. I’m sure you can set similar headers in Java:

$file = "file.xlsx";
header('Content-disposition: attachment; filename=".$file);
header("Content-Length: ' . filesize($file));
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');
echo json_encode(readfile($file));

Edit 20.04.2016

Browsers are making it harder to save data this way. One good option is to use filesaver.js. It provides a cross browser implementation for saveAs, and it should replace some of the code in the success promise above.

More Related Contents:

  1. Parsing JSON in Excel VBA
  2. AngularJS: factory $http.get JSON file
  3. Nested ng-repeat
  4. Returning Null JSON Throwing Type Mismatch Error in VBA
  5. Excel VBA: Parsed JSON Object Loop
  6. One dimensional array of strings being parsed to 2d by angular resource
  7. In Excel VBA on Windows, for parsed JSON variables what is this JScriptTypeInfo anyway?
  8. In Excel VBA on Windows, how to get stringified JSON respresentation instead of “[object Object]” for parsed JSON variables?
  9. AngularJS Intercept all $http JSON responses
  10. Post JSON to web in excel vba
  11. Handle JSON Object in XMLHttp response in Excel VBA Code
  12. Filter Array Using Checkboxes with AngularJS
  13. Binary Data in JSON String. Something better than Base64
  14. XSLT equivalent for JSON
  15. Why is JSON invalid if an integer begins with a leading zero?
  16. How to merge 2 JSON objects from 2 files using jq?
  17. Select objects based on value of variable in object using jq
  18. Parsing JSON DateTime from Newtonsoft’s JSON Serializer
  19. OpenAPI: what schema to accept any (complex) JSON value
  20. Why struct fields are showing empty?
  21. How do I add environment variables to launch.json in VSCode
  22. Partly JSON unmarshal into a map in Go
  23. How do I update a single value in a json document using jq?
  24. How to create multiple tables in jasper report using json as a datasource?
  25. Cannot convert PSCustomObjects within array back to JSON correctly
  26. How to use jq when the variable has reserved characters?
  27. Check if a Postgres JSON array contains a string
  28. How can I do JSON serializer ignore navigation properties?
  29. Error handling using JSONDecoder in Swift
  30. Load static JSON file in Webpack

Leave a Comment