JavaScript Data GridExcel Export API Reference
Enterprise

This page documents the Excel Export API and Interfaces.

Grid Properties

defaultExcelExportParams TypeExcelExportParams	A default configuration object used to export to Excel.
suppressExcelExport Typeboolean Defaultfalse	Prevents the user from exporting the grid to Excel.
excelStyles TypeExcelStyle[] Initial	A list (array) of Excel styles to be used when exporting to Excel with styles.

API Methods

exportDataAsExcel TypeFunction	Downloads an Excel export of the grid's data.
getDataAsExcel TypeFunction	Similar to `exportDataAsExcel`, except instead of downloading a file, it will return a Blob to be processed by the user.
getSheetDataForExcel TypeFunction	This is method to be used to get the grid's data as a sheet, that will later be exported either by `getMultipleSheetsAsExcel()` or `exportMultipleSheetsAsExcel()`.
exportMultipleSheetsAsExcel TypeFunction	Downloads an Excel export of multiple sheets in one file.
getMultipleSheetsAsExcel TypeFunction	Similar to `exportMultipleSheetsAsExcel`, except instead of downloading a file, it will return a Blob to be processed by the user.

Interfaces

ExcelExportParams

Properties available on the ExcelExportParams interface.

author Typestring Default"AG Grid"	The author of the exported file. @default "AG Grid"
autoConvertFormulas Typeboolean Defaultfalse	If set to `true`, this will try to convert any cell that starts with `=` to a formula, instead of setting the cell value as regular string that starts with `=`.
columnWidth Typenumber \| ((params: ColumnWidthCallbackParams) => number)	Defines the default column width. If no value is present, each column will have value currently set in the application with a min value of 75px. This property can also be supplied a callback function that returns a number.
fontSize Typenumber Default11	The default value for the font size of the Excel document.
headerRowHeight Typenumber \| ((params: RowHeightCallbackParams) => number)	The height in pixels of header rows. Defaults to Excel default value. This property can also be supplied a callback function that returns a number.
rowHeight Typenumber \| ((params: RowHeightCallbackParams) => number)	The height in pixels of all rows. Defaults to Excel default value. This property can also be supplied a callback function that returns a number.
sheetName Typestring Default'ag-grid'	The name of the sheet in Excel where the grid will be exported. There is a max limit of 31 characters.
margins TypeExcelSheetMargin	The Excel document page margins. Relevant for printing.
pageSetup TypeExcelSheetPageSetup	Allows you to setup the page orientation and size.
headerFooterConfig TypeExcelHeaderFooterConfig	The configuration for header and footers.
suppressRowOutline Typeboolean Defaultfalse.	If `true`, the outline (controls to expand and collapse) for Row Groups will not be added automatically to the Excel Document.
suppressColumnOutline Typeboolean Defaultfalse.	If `true`, the outline (controls to expand and collapse) for Group Columns will not be added automatically to the Excel Document.
rowGroupExpandState Type'expanded' \| 'collapsed' \| 'match' Default'expanded'	The expand/collapse state of each row group in the Excel Document. expanded: All row groups will be expanded by default. collapsed: All row groups will be collapsed by default. match: The row groups will match their current state in the Grid.
mimeType Typestring Default'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'	The mimeType of the Excel file.
addImageToCell TypeFunction	Use to export an image for the gridCell in question.
prependContent TypeExcelRow[]	Content to put at the bottom of the exported sheet. An array of ExcelRow objects, see Extra Content section.
appendContent TypeExcelRow[]	Content to put at the top of the exported sheet. An array of ExcelRow objects, see Extra Content section.
getCustomContentBelowRow TypeFunction	A callback function to return content to be inserted below a row in the export.
allColumns Typeboolean Defaultfalse	If `true`, all columns will be exported in the order they appear in the columnDefs. When `false` only the columns currently being displayed will be exported.
columnKeys Type(string \| Column)[]	Provide a list (an array) of column keys or Column objects if you want to export specific columns.
rowPositions TypeRowPosition[]	Row node positions.
fileName Typestring Defaultexport.xlsx	String to use as the file name.
exportedRows Type'all' \| 'filteredAndSorted' Default'filteredAndSorted'	Determines whether rows are exported before being filtered and sorted.
onlySelected Typeboolean Defaultfalse	Export only selected rows.
onlySelectedAllPages Typeboolean Defaultfalse	Only export selected rows including other pages (only makes sense when using pagination).
skipColumnGroupHeaders Typeboolean Defaultfalse	Set to `true` to exclude header column groups.
skipColumnHeaders Typeboolean Defaultfalse	Set to `true` if you don't want to export column headers.
skipRowGroups Typeboolean Defaultfalse	Set to `true` to skip row group headers if grouping rows. Only relevant when grouping rows.
skipPinnedTop Typeboolean Defaultfalse	Set to `true` to suppress exporting rows pinned to the top of the grid.
skipPinnedBottom Typeboolean Defaultfalse	Set to `true` to suppress exporting rows pinned to the bottom of the grid.
shouldRowBeSkipped TypeFunction	A callback function that will be invoked once per row in the grid. Return true to omit the row from the export.
processCellCallback TypeFunction	A callback function invoked once per cell in the grid. Return a string value to be displayed in the export. For example this is useful for formatting date values.
processHeaderCallback TypeFunction	A callback function invoked once per column. Return a string to be displayed in the column header.
processGroupHeaderCallback TypeFunction	A callback function invoked once per column group. Return a `string` to be displayed in the column group header. Note that column groups are exported by default, this option will not work with `skipColumnGroupHeaders=true`.
processRowGroupCallback TypeFunction	A callback function invoked once per row group. Return a `string` to be displayed in the group cell.

ExcelExportMultipleSheetParams

Properties available on the ExcelExportMultipleSheetParams interface.

See Multiple Sheets for more information.

author Typestring Default'AG Grid'	The author of the exported file.
data Typestring[]	Array of strings containing the raw data for Excel workbook sheets. This property is only used when exporting to multiple sheets using `api.exportMultipleSheetsAsExcel()` and the data for each sheet is obtained by calling `api.getSheetDataForExcel()`.
fileName Typestring Default'export.xlsx'	String to use as the file name.
fontSize Typenumber Default11	The default value for the font size of the Excel document.
mimeType Typestring Default'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'	The mimeType of the Excel file.

ExcelAlignment

Properties available on the ExcelAlignment interface.

horizontal Type'Automatic' \| 'Left' \| 'Center' \| 'Right' \| 'Fill' \| 'Justify' \| 'CenterAcrossSelection' \| 'Distributed' \| 'JustifyDistributed' Default'Automatic'	Use this property to change the cell horizontal alignment.
indent Typenumber Default0	Use this property to change the level of indentation in the cell.
readingOrder Type'RightToLeft' \| 'LeftToRight' \| 'Context' Default'LeftToRight'	Use this property to change the cell reading order.
rotate Typenumber Default0	The number of degrees between 0 and 359 to rotate the text.
shrinkToFit Typeboolean Defaultfalse	If set to `true`, the font size of the cell will automatically change to force the text to fit within the cell.
vertical Type'Automatic' \| 'Top' \| 'Bottom' \| 'Center' \| 'Justify' \| 'Distributed' \| 'JustifyDistributed' Default'Automatic'	Use this property to change the cell vertical alignment.
wrapText Typeboolean Defaultfalse	If set to `true`, multiline text will be displayed as multiline by Excel.

ExcelBorders

Properties available on the ExcelBorders interface.

borderBottom TypeExcelBorder	Use to set the cell's bottom border.
borderLeft TypeExcelBorder	Use to set the cell's left border.
borderRight TypeExcelBorder	Use to set the cell's right border.
borderTop TypeExcelBorder	Use to set the cell's top border.

ExcelBorder

Properties available on the ExcelBorder interface.

color Typestring Default'black'	The color or the border.
lineStyle Type'None' \| 'Continuous' \| 'Dash' \| 'Dot' \| 'DashDot' \| 'DashDotDot' \| 'SlantDashDot' \| 'Double' Default'None'	The style of the border.
weight Type0 \| 1 \| 2 \| 3 Default0	The thickness of the border from 0 (thin) to 3 (thick).

ExcelCell

Properties available on the ExcelCell interface.

data TypeExcelData	The data that will be added to the cell.
ref Typestring	Cell reference.
collapsibleRanges Typenumber[][]	Collapsible ranges.
styleId Typestring \| string[]	The ExcelStyle id to be associated with the cell.
mergeAcross Typenumber Default0	The number of cells to span across (1 means span 2 columns).

ExcelData

Properties available on the ExcelData interface.

type * TypeExcelDataType \| ExcelOOXMLDataType	The type of data being in the cell.
value * Typestring \| null	The value of the cell.

ExcelFont

Properties available on the ExcelFont interface.

bold Typeboolean Defaultfalse	Set to `true` to set the cell text to bold.
color Typestring Default'#000000'	The color of the cell font.
family Typestring Default'Automatic'	The family of the font to used in the cell. Options: `Automatic`,`Roman`,`Swiss`,`Modern`,`Script`,`Decorative`,
fontName Typestring Default'Calibri'	The name of the font to be used in the cell.
italic Typeboolean Defaultfalse	Set to `true` to display the cell font as italic.
outline Typeboolean Defaultfalse	Set to `true` to add a text outline.
shadow Typeboolean Defaultfalse	Set to `true` to add text shadow.
size Typenumber	Set this property to used a different font size other than the default.
strikeThrough Typeboolean Defaultfalse	Set to `true` to add a strikeThrough line.
underline Type'Single' \| 'Double'	Use this property to underline the cell text.
verticalAlign Type'Superscript' \| 'Subscript'	Use this property to change the default font alignment. Note: This is different than setting cell vertical alignment.

ExcelHeaderFooter

Properties available on the ExcelHeaderFooter interface.

header TypeExcelHeaderFooterContent[]	An array of maximum 3 items (`Left`, `Center`, `Right`), containing header configurations.
footer TypeExcelHeaderFooterContent[]	An array of maximum 3 items (`Left`, `Center`, `Right`), containing footer configurations.

ExcelHeaderFooterContent

Properties available on the ExcelHeaderFooterContent interface.

value * Typestring	The value of the text to be included in the header.
position Type'Left' \| 'Center' \| 'Right' Default'Left'	Configures where the text should be added: `Left`, `Center` or `Right`.
font TypeExcelFont	The font style of the header/footer value.

ExcelImage

Properties available on the ExcelImage interface.

id * Typestring	The image `id`. This field is required so the same image doesn't get imported multiple times.
base64 * Typestring	A base64 string that represents the image being imported. See: Base64
imageType * Type'jpg' \| 'png' \| 'gif'	The type of image being exported.
altText Typestring	Alt Text for the image.
fitCell Typeboolean Defaultfalse	If set to `true`, the image will cover the whole cell that is being imported to.
transparency Typenumber Default0	Set a value between 0 - 100 that will indicate the percentage of transparency of the image.
rotation Typenumber Default0	Set a value between 0 - 359 that will indicate the number of degrees to rotate the image clockwise.
recolor Type'Grayscale' \| 'Sepia' \| 'Washout'	Set this property to select a preset that changes the appearance of the image.
width Typenumber	The width of the image in pixels. If this value is not selected, `fitCell` will be automatically set to true.
height Typenumber	The height of the image in pixels. If this value is not selected, `fitCell` will be automatically set to true.
position TypeExcelImagePosition	Position of the image.

ExcelImagePosition

Properties available on the ExcelImagePosition interface.

row Typenumber	The row containing this image. This property is set automatically, don't change it unless you know what you are doing.
rowSpan Typenumber Default1	The amount of rows this image will cover. @default 1
column Typenumber	The column containing this image. This property is set automatically, don't change it unless you know what you are doing.
colSpan Typenumber Default1	The amount of columns this image will cover.
offsetX Typenumber Default0	The amount in pixels the image should be offset horizontally.
offsetY Typenumber Default0	The amount in pixels the image should be offset vertically.

ExcelInterior

Properties available on the ExcelInterior interface.

pattern Type'None' \| 'Solid' \| 'Gray75' \| 'Gray50' \| 'Gray25' \| 'Gray125' \| 'Gray0625' \| 'HorzStripe' \| 'VertStripe' \| 'ReverseDiagStripe' \| 'DiagStripe' \| 'DiagCross' \| 'ThickDiagCross' \| 'ThinHorzStripe' \| 'ThinVertStripe' \| 'ThinReverseDiagStripe' \| 'ThinDiagStripe' \| 'ThinHorzCross' \| 'ThinDiagCross'	Use this property to set background color patterns.
color Typestring	The colour to be used as a secondary colour combined with patterns.
patternColor Typestring	The pattern color.

ExcelNumberFormat

Properties available on the ExcelNumberFormat interface.

Typestring

Use this property to provide a pattern to format a number. (eg. 10000 could become $10,000.00).

ExcelProtection

Properties available on the ExcelProtection interface.

protected Typeboolean Defaulttrue	Set to `false` to disable cell protection (locking)
hideFormula Typeboolean Defaultfalse	Set to `true` to hide formulas within protected cells.

ExcelSheetMargin

Properties available on the ExcelSheetMargin interface.

top Typenumber Default0.75	The sheet top margin.
right Typenumber Default0.7	The sheet right margin.
bottom Typenumber Default0.75	The sheet bottom margin.
left Typenumber Default0.7	The sheet left margin.
header Typenumber Default0.3	The sheet header margin.
footer Typenumber Default0.3	The sheet footer margin.

ExcelSheetPageSetup

Properties available on the ExcelSheetPageSetup interface.

orientation Type'Portrait' \| 'Landscape' Default'Portrait'	Use this property to change the print orientation.
pageSize Type'Letter' \| 'Letter Small' \| 'Tabloid' \| 'Ledger' \| 'Legal' \| 'Statement' \| 'Executive' \| 'A3' \| 'A4' \| 'A4 Small' \| 'A5' \| 'A6' \| 'B4' \| 'B5' \| 'Folio' \| 'Envelope' \| 'Envelope DL' \| 'Envelope C5' \| 'Envelope B5' \| 'Envelope C3' \| 'Envelope C4' \| 'Envelope C6' \| 'Envelope Monarch' \| 'Japanese Postcard' \| 'Japanese Double Postcard' Default'Letter'	Use this property to set the sheet size.

ExcelStyle

Properties available on the ExcelStyle interface.

id * Typestring	The id of the Excel Style, this should match a CSS cell class.
alignment TypeExcelAlignment	Use this property to customise cell alignment properties.
borders TypeExcelBorders	Use this property to customise cell borders.
dataType TypeExcelDataType	Use this property to specify the type of data being exported.
font TypeExcelFont	Use this property to customise the font used in the cell.
interior TypeExcelInterior	Use this property to customise the cell background.
numberFormat TypeExcelNumberFormat	Use this property to customise the cell value as a formatted number.
protection TypeExcelProtection	Use this property to setup cell protection.

Types

ExcelDataType

type ExcelDataType = 
    'String'   |
    'Formula'  |
    'Number'   |
    'Boolean'  |
    'DateTime' |
    'Error'

ExcelOOXMLDataType

type ExcelOOXMLDataType = 
    'str'       |
    's'         |
    'f'         |
    'inlineStr' |
    'n'         |
    'b'         |
    'd'         |
    'e'         |
    'empty'

Grid Properties

defaultExcelExportParams

suppressExcelExport

excelStyles

API Methods

exportDataAsExcel

getDataAsExcel

getSheetDataForExcel

exportMultipleSheetsAsExcel

getMultipleSheetsAsExcel

Interfaces

ExcelExportParams

author

autoConvertFormulas

columnWidth

fontSize

headerRowHeight

rowHeight

sheetName

margins

pageSetup

headerFooterConfig

suppressRowOutline

suppressColumnOutline

rowGroupExpandState

mimeType

addImageToCell

prependContent

appendContent

getCustomContentBelowRow

allColumns

columnKeys

rowPositions

fileName

exportedRows

onlySelected

onlySelectedAllPages

skipColumnGroupHeaders

skipColumnHeaders

skipRowGroups

skipPinnedTop

skipPinnedBottom

shouldRowBeSkipped

processCellCallback

processHeaderCallback

processGroupHeaderCallback

processRowGroupCallback

ExcelExportMultipleSheetParams

author

data

fileName

fontSize

mimeType

ExcelAlignment

horizontal

indent

readingOrder

rotate

shrinkToFit

vertical

wrapText

ExcelBorders

borderBottom

borderLeft

borderRight

borderTop

ExcelBorder

color

lineStyle

weight

ExcelCell

data

ref

collapsibleRanges

styleId

mergeAcross

ExcelData

type *

value *

ExcelFont