Menu
  • HOME
  • TAGS

How to set custom header names with ALASQL and XLSX

angularjs,excel,xlsx,alasql

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....

How do you create a time field in AlaSQL

javascript,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...