Pivot export to excel

Webix JS
1

Hi Team,
there is any way to export pivot from out side i mean i will create one button and call function with row column and value parameter.

2

Hi,

Generally, you can use a simple

{   view:"button", click:function(){ webix.toExcel($$("pivot"))}    }

But if you use a function like

webix.toExcel($$("pivot"), {
    columns:{
        "name":true
    }
}

(as described here), the method will return a values directly from the dataset, without any Pivot formatting.

3

Also, if you need to get the config of pivot, not its data, you can use getStructure API

http://docs.webix.com/desktop__pivot.html#api

4

Hi, I am subscribing for a demo. I am trying to export a pivot table to excel, I have two levels in columns. When the file is exported, only the last level is shown in the columns headers with an error in the first column of each group, it is showing the name of first level. Is there any way to export columns same way as they show in the pivot?

5

Hi @snajjar,

I can confirm the issue. It will be fixed in the next release (scheduled for the end of April)