How to set custom header names with ALASQL and XLSX

Question

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?

score 11 · Answer 1 · answered Feb 18 '16 at 15:22

Sometimes you want to use Headers including blank spaces (Separated By) or... using headers that are reserved words (Deleted), in both cases you can use [] like this:

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

score 5 · Accepted Answer · answered Jun 13 '15 at 23:53

5

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.

answered Jun 13 '15 at 23:53

Luis Crespo

1,610
1
20
33

How to set custom header names with ALASQL and XLSX

2 Answers2