Exporting

28 Sep 20174 minutes to read

The PivotChart control can be exported to the following file formats.

• Excel
• Word
• PDF
• Image

The PivotChart control can be exported by invoking “exportPivotChart” method, with an appropriate export option as parameter.

HTML

<ej-pivotchart [dataSource]="dataSource"></ej-pivotchart>
<input id="btnExport" ej-button size="normal" (click)="onExport($event)" value="Export"

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/ExcelExport","fileName");
    }
}

Excel Export

User can export contents of the PivotChart to Excel document for future archival, references and analysis purposes.

To achieve Excel export, service URL and file name is sent as the parameter.

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/ExcelExport","fileName");
    }
}

Word Export

User can export contents of the PivotChart to Word document for future archival, references and analysis purposes.

To achieve Word export, service URL and file name is sent as the parameter.

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/WordExport","fileName");
    }
}

PDF Export

User can export contents of the PivotChart to PDF document for future archival, references and analysis purposes.

To achieve PDF export, service URL and file name is sent as the parameter.

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/PDFExport","fileName");
    }
}

Image Export

User can export contents of the PivotChart to image format for future archival, references and analysis purposes. We can export PivotChart to the following image formats.

• PNG
• EMF
• JPG
• GIF
• BMP

To export PivotChart in PNG format, service URL, file name and “ej.PivotChart.ExportOptions.PNG” enumeration value is sent as the parameter. This is similar to other image formats.

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/ImageExport","fileName", ej.PivotChart.ExportOptions.PNG);
    }
}

Exporting Customization

You can add title and description to the exporting document by using title and description property obtained in the “beforeExport” event.

NOTE

Title and description cannot be added to image formats.

HTML

<ej-pivotchart [dataSource]="dataSource" (beforeExport)="beforeExport($event)"></ej-pivotchart>
<input id="btnExport" ej-button size="normal" (click)="onExport($event)" value="Export"

TS

export class PivotChartComponent {
    //..
    onExport() {
        let chartObj = $('.e-pivotchart').data("ejPivotChart");
        chartObj.exportPivotChart("http://js.syncfusion.com/ejservices/api/PivotChart/Olap/ExcelExport","fileName");
    }
    beforeExport(args) {
        args.title = "PivotChart";
        args.description = "Visualizes both OLAP and Relational datasource in graphical format";
    }
}

The below screenshot shows the PivotChart control exported to Excel document.

The below screenshot shows the PivotChart control exported to Word document.

The below screenshot shows the PivotChart control exported to PDF document.

The below screenshot shows the PivotChart control exported to PNG format.