How do you create a time field in AlaSQL
There are two methods to use date/time fields in AlaSQL: Use DATE and DATETIME data types. In this case AlaSQL stores data in text fotmat, like: 'YYYYMMDD' and 'YYYYMMDDHHMMSS' Another options is to use Date (with first upper case "D" and other lower case letters) data type. In this case...
How to set custom header names with ALASQL and XLSX
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....