luisincrespo luisincrespo - 1 year ago 541
AngularJS Question

How to set custom header names with ALASQL and XLSX

I'm exporting some tables to excel, using angular, alasql and xlsx. I'm using it as follows:

var options = {
headers: true,
sheetid: 'users',
columns: [{
columnid: 'a',
title: 'Username'
}, {
columnid: 'b',
title: 'First name'
}, {
columnid: 'c',
title: 'Last name'

alasql('SELECT * INTO XLSX("test.xlsx", ?) FROM ?', [options, $scope.users]);

I was expecting the columnns option to customize my table headers. But it ain't doing it.

Any clue why?

Answer Source

I managed to customize the headers by using plain SQL:

alasql('SELECT firstName AS FirstName INTO XLSX("test.xlsx", ?) FROM ?', [options, $scope.users]);

That worked, the header for the firstName would be FirstName.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download