trantrunghieu0809/json-export-excel

export excel from json using AngularJS

ngJsonExportExcel - export excel from json using AngularJS

How to get it ?

Bower

bower install ng-json-export-excel --save

Usage

1. Add json-export-excel.js and FileSaver.js to your main file (index.html)

2. Set ngJsonExportExcel as a dependency in your module

var myapp = angular.module('myapp', ['ngJsonExportExcel'])

3. Example simple:

<button ng-json-export-excel data="dataList" report-fields="{'uesr.username': 'Heder 1', keyjson2: 'Header 2', keyjson3: 'Head 3'}" filename =" 'export-excel' " separator="," class="css-class"></button>

Default filename = 'export-excel'

Default separator = ';'

4. Please find examples in the directory example or You can check out this live example here: http://plnkr.co/6ieuJ1khmKFds9VYHoDv

json-export-excel's Issues

How to set report-fields ,use $scope

for example
<button ng-json-export-excel data="datalist" report-fields="select" filename="'filename'" separator=',' class="btn-sm btn-primary">Export Excel</button>

$scope.select = "{id: 'ID Heder', DeviceName: 'DeviceName', udeviceId: 'udeviceId'}"

Data not getting displayed properly

If any value contains the character comma then while opening in excel data is not getting displayed properly. Any workaround to fix this problem.

How to add title in first line on csv? followed by headdes.

always export as .csv file

Hi,
this module always export as csv file. Is there any way to export as with excel extension?

Export excel need a filter

export excel need a filter

Is it possible to include some static messages at bottom of the excel document?

Example:
I have data objects that looks like below.

$scope.dataList = [
                    {
                        id: 1,
                        name: 'github',
                        price: '200$',
                        publisher: {
                            name: 'hieutran',
                            company: 'Dtag-VN'
                        }
                    },
                    {
                        id: 2,
                        name: 'google',
                        price: '300$',
                        publisher: {
                            name: 'tran',
                            company: 'Vietname'
                        }
                    }
                ];
$scope.Messages= ["Message 1","Message 2","Message 3"];

Right now, I am able to generate a Excel using only one data object as below.

<button ng-json-export-excel data="dataList" report-fields="{id: 'ID Heder', name: 'Name Header', price: 'Price Head'}" filename="'filename'" class="btn-sm btn-primary">Export Excel</button>

I'm looking for a solution to achieve below report.

Is this possible here?

Save csv file to a specific folder

Hello, Please is it possible to save save the generated .csv file to a specific folder without the popup.
Thanks

Returning blank string for date type object

when a field is date type then it is always returning "" as value. I have modified file to add check for date type object. see if its helpful

function _objectToString(object) {
var output = '';
if(angular.isDate(object)){
return object.toLocaleDateString();
}
angular.forEach(object, function(value, key) {
output += key + ':' + value + ' ';
});

                    return '"' + output + '"';
                }

Data is displayed in one column only

Sometimes when I export the data to csv file, the data is displayed in the first column only. I have tried this on different platforms and it works on both and also displays incorrectly on both so I can't figure out the cause so far.

One thing I came across was the separator to be , and I believe this is already done here:
<button class="btn btn-sm btn-warning" ng-json-export-excel data="reports_index.models" report-fields="{'user_name': 'User', 'title': 'Title', 'department': 'Department', 'senior': 'Senior', 'assessment_name': 'Assessment Name', 'product_name': 'Product Name', 'submission_date': 'Submission Date', 'country': 'Country', 'score': 'Score'}", filename =" 'report' " class="css-class">Export</button>

thank you for this

through your repo, I find FileSaver.js and find this issue
mybe this will help me to export excel

$scope.separator

With the new $scope.separator addition we might need to either update the example to include: separator="," or change the default separator on line 19: to ','.

Thanks,
Kevin

can you make report fileds as optional parameter and get col names from datalist

can you make report fileds as optional parameter and get col names from datalist

Fetch data on click event

Hi,
The way your plugin works is that data should be available when user click on the button. Is there any way to call web api service first, when user clicks on a button?

Thanks,
Igor

Not working in Internet Explorer

I tried this package but it does not work on internet explorer, Can you fix this ?

default format of exported file is csv.

Hi,
Default format of exported file is csv.

I have modified file extension in FileSaver.js.

Its exporting now excel files with .xls format. But when I open it using Microsoft Excel it gives following warning everytime.

'The file format and extension do not match. file can be corrupted or unsafe.Unless you know this source don't open it. Do you want to open it anyway ?' : Yes : No

Is there any way to remove this warning ?

Regards