Search results

BeforeExportEventArgs API in JavaScript (ES5) Pivot Table API control

The before export event arguments provides the necessary information to customize before exporting the file.

Properties

allowRepeatHeader

boolean

Defines option to disable the repeat headers

columnSize

number

Defines the number of columns that will be exported for each PDF page.

This option is applicable only when exporting the pivot table to PDF document.

currentExportView

ExportView

Determines if the table or chart will be exported to the current document.

dataCollections

IAxisSet[][]

Defines pivot table cell collections

excelExportProperties

ExcelExportProperties

Defines the additional settings for excel export such as multiple export, header, footer, etc.

fileName

string

Defines exported field name

Defines footer text

Defines header text

height

number

Defines content height to be export

isBlob

boolean

A file-like object of immutable, raw data. Blobs represent data that isn’t necessarily in a JavaScript-native format. The File interface is based on Blob, inheriting blob functionality and expanding it to support files on the user’s system.

isMultipleExport

boolean

Defines an option to export multiple pivot table to the same PDF file

orientation

PdfPageOrientation

Defines the page orientation of PDF export

pdfDoc

Object

Defines current PDF file that holds the pivot table information which will be used to export

pdfExportProperties

PdfExportProperties

Defines the additional settings for PDF export such as page size, orientation, header, footer, etc.

pdfMargins

PdfMargins

Specifies the margins of a PDF document when exporting a pivot table or pivot chart.

style

PdfTheme

Defines the theme style for PDF

type

ExportType

Defines the pivot chart export type

width

number

Defines content width to be export

workbook

any

Defines current excel work book that holds the pivot table information which will be used to export