1

how can i extract spreadsheet with a wraptext using alasql, this is what i thought will work :

var mystyle = {
    headers: true,
    columns: [{
        columnid: 'Description',
        width: 50,
        wraptext: true
    }],
    rows: {
        1: {
            style: {
                Font: {
                    Color: "#FF0077"
                }
            }
        }
    },
    cells: {
        1: {
            1: {
                style: {
                    Font: {
                        Color: "#00FFFF"
                    }
                }
            }
        }
    }
};
$scope.exportMyData = function() {
    alasql('SELECT * INTO XLSXML("john.xls",?) FROM ?', [mystyle, $scope.gridOptions.data]);
}
Sachila Ranawaka
  • 39,756
  • 7
  • 56
  • 80
user2848242
  • 177
  • 1
  • 11

0 Answers0