1

I am using AlaSql version 0.4.2. I am exporting to excel through following way :

var mystyle = {
     headers: true,
     sheetid: 'Counter Correction',
  };

            //Create XLS format using alasql.js file.
            var excelHistoricalFileName = "HistoricalDataExport_" + $rootScope.Park_Name + "_" + $rootScope.turbineName + "_" + $rootScope.selectedTurbineSerialNum + ".xls";

            var excelObj = alasql('SELECT * INTO XLS("' + excelHistoricalFileName + '",?) FROM ?', [mystyle, data]);

The output excel is attached for reference at link : https://github.com/agershun/alasql/issues/966

I need the following through alasql formatting options :

Row 1, Column A, and Column B should be freezed.

All column should be angle aligned as mentioned in the screenshot. ExcelFormatting.png

Jobin
  • 5,610
  • 5
  • 38
  • 53

0 Answers0