angular in excel export

Question

In my excel-export.html I have:

<div class="config-menu-container first">

            <div class="menu-title">
        <span class="excel import">Excel import</span>
                <span class="excel export">Excel Export</span>
            </div>

            <ul class="menu-body step2" id="exportable">
                <li class="title">
                    <span class="label main order first”>1</span>
                    <span class="label main order second”>2</span>
                    <span class="label main order third”>3</span>
                </li>
                <li class="row" ng-repeat="device in devices">
                    <span class="label sub first" ng-bind="device.deviceId" ng-click="deviceScope = device.id"></span>
                    <span class="input second">
                        <custom-input type="text" width="330" height="24" model="device.name"></custom-input>
                    </span>
                    <span class="input third" ng-repeat-end>
                        <custom-input type="select2" width="462" height="24" label=“Select Device."
                                      options="option.billingInfo" model="device.billingTargetId"></custom-input>
                    </span>
                </li>
            </ul>
</div>

In my excel-export.directive.js I have:

'use strict';

angular.module('bemsApp')
  .directive('excelExport', function () {
    return {
      templateUrl: 'app/directives/excel-export/excel-export.html',
      restrict: 'EA',
      link: function (scope, element, attrs) {
          scope.exportData = function () {
                var blob = new Blob([document.getElementById('exportable').innerHTML], {
                    type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8"
                });
                saveAs(blob, "Report.xls");
            };
      }
    };
  });

When I try to save the Excel file, an error occurs saveAs did not define.

I have to separately define the saveAs function wondering if there is a way to save the Excel file.

You need a Filesaver.js library since FileSaver intervace is removed from the html5 specs. See the doc http://updates.html5rocks.com/2011/08/Saving-generated-files-on-the-client-side — iiro, Mar 31 '15 at 05:23
Won't the `` tag work, like described in answer [here](http://stackoverflow.com/questions/11336663/how-to-make-a-browser-display-a-save-as-dialog-so-the-user-can-save-the-conten)? — Kirill Slatin, Mar 31 '15 at 05:38
@iiro is correct. But why not make it an answer, would upvote. — deitch, Mar 31 '15 at 05:42
It might help you. http://www.code-sample.com/2014/12/export-ng-grid-data-to-excel-csv-and.html — , Mar 31 '15 at 05:43
I was successful by far is to create an Excel file containing the Filesaver.js. So you open an Excel file, not an HTML tag that data into output unchanged. In order to output in Excel format would you want to do this any other way? — bismute, Mar 31 '15 at 05:43
@deitch ok i put it to answer. But it is just one google search .. — iiro, Mar 31 '15 at 05:44

score 4 · Accepted Answer · answered Mar 31 '15 at 05:46

4

You need a Filesaver.js library since FileSaver interface is removed from the html5 specs. See the doc

http://updates.html5rocks.com/2011/08/Saving-generated-files-on-the-client-side

answered Mar 31 '15 at 05:46

iiro

3,132
1
19
22

I was successful by far is to create an Excel file containing the Filesaver.js. So you open an Excel file, not an HTML tag that data into output unchanged. In order to output in Excel format would you want to do this any other way? – bismute Mar 31 '15 at 07:04
@bismute sorry but i don't really understand what do you mean now? Could you clarify a bit? – iiro Mar 31 '15 at 07:19

angular in excel export

1 Answers1