Alasql: Setting for header ignored for xlsx

[mathiasrw]

Setting header:false is ignored in the following example: http://jsfiddle.net/sd7822df/

It generates 2 worksheets both having headers...

[ashaik27]

Hi,

Is is possible to set headers:false and specify header names in a custom array.

[mathiasrw]

Having headers=true you can set header name by giving an alias to the select

SELECT id, name , maxpaysomethig as Pay FROM ...

[ashaik27]

Good Morning,

I have custom names specified using title for columns array as below. Right now I have all clomuns headers displayed in a row but I am looking forward to group them by category/term.
columns: [
{ columnid: 'Overall Scores_F_Lexile Measure', title: 'Overall Scores_F_Lexile Measure'},
{ columnid: 'Overall Scores_F_RIT Score', title: 'Overall Scores_F_RIT Score' },
.....]
I am looking to achieve custom header names to group/sub group few headers by category.

In the above image single level header's are grouped and displayed (F: Fall, W:Winter, S:Spring and category(overall/Literature))

Below is view part of it using UI Grid. I'm trying to achieve similar grouping as below in a downloadable excel format

So I started looking for is there a way to specify or customize header's declaration out of column declaration through a custom array . Display part grouping of column headers is implemented through UI Grid Cell template feature in UI Grid and am trying to implement download excel feature. Alasql XSL is very helpful for me to get a working xsl in limited amount of time with color coding. I have to look forward to search if there is a way to specify custom/grouped header templates through Alasql-XSL.

Is this something that can be achievable using @alasql-xsl() ?

Thanks for your help!

Thanks,
Aman

[mathiasrw]

You can not do that with alasql. For being creative with excel - please use https://github.com/SheetJS/js-xlsx

[ashaik27]

Great Thanks!