Styling not working with xlsx format?

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

http://alasql.org

MIT License

7.04k stars 659 forks source link

Styling not working with xlsx format? #1165

Open yamanksin opened 4 years ago

yamanksin commented 4 years ago

AlaSQL is based on unpaid voluntary work. Thank you for taking the time to make it better.

Question about how to ...

Please use http://stackoverflow.com/questions/ask?tags=alasql

Something is not working as expected:

Describe the problem
Provide code that replicates the problem
We suggest to spawn a jsfiddle from http://jsfiddle.net/98qL7m0c/

yamanksin commented 4 years ago

var mystyle = { headers:true, column: {style:{Font:{Bold:"1"}}}, rows: {1:{style:{Font:{Color:"#FF0077"}}}}, cells: {1:{1:{ style: {Font:{Color:"#00FFFF"}} }}} }

        alasql('SELECT * INTO XLSX("'+fileName+".xlsx"+'",?) FROM ?',[mystyle ,data]);