title: How to give color to excel row while exporting data using alasql - angularjs sql api
body: <p>I am little confused to give styling for excel rows while exporting the data using alasql. Below is the code that I am working on</p>
  
  <pre><code>$scope.exportData = function () {
  
  var mystyle = {
              sheetid: 'Test_sheet',
              headers: true,
              column: {
                  style:'font-size:18px;background:green'
              },
              columns: [
                  {columnid:'field1', width:120},
                  {columnid:'field2', width:200},
                  {columnid:'field3', width:350},
                  {columnid:'field4', width:100},
              ],
              row: {
  
              },
              rows: {
  
              },
              cells: {
  
              }
          };
  
          alasql('SELECT field1,field2,field3,field4,field5 INTO XLS("Test.xls",?) FROM ?',[mystyle, $scope.data.results]);
  
  };
  </code></pre>
  
  <p>Here, based on field5 value, I wanted to assign the background color of the entire row while exporting the data to excel sheet. Any idea how to modify the 'mystyle' variable?</p>