bootstrap-table/site/docs/extensions/export.md

---

layout: docs title: Table Export description: Table Export extension of Bootstrap Table. group: extensions

toc: true

Use Plugin: tableExport.jquery.plugin

This is an important link to check out as some file types may require extra steps.

Usage

{% highlight html %} {% endhighlight %}

Example

Export

Options

showExport

• Attribute: data-show-export

• type: Boolean

• Detail:

set true to show export button.

• Default: false

exportDataType

• Attribute: data-export-data-type

• type: String

• Detail:

export data type, support: 'basic', 'all', 'selected'.

• Default: basic

exportFooter

• Attribute: data-export-footer

• type: Boolean

• Detail:

set true to export the table footer.

• Default: false

exportOptions

• Attribute: data-export-options

• type: Object

• Detail:

export options of tableExport.jquery.plugin

exportOptions.fileName can be a string or a function, for example:

   exportOptions: {
      fileName: function () {
         return 'exportName'
      }
   }

exportTypes

• Attribute: data-export-types

• type: Array

• Detail:

export types, support types: 'json', 'xml', 'png', 'csv', 'txt', 'sql', 'doc', 'excel', 'xlsx', 'pdf'.

• Default: ['json', 'xml', 'csv', 'txt', 'sql', 'excel']

• Default: {}

Icons

• export: 'glyphicon-export icon-share'

Column options

forceExport

• Attribute: data-force-export

• type: Boolean

• Detail:

Set true to force export a column e.g. hidden columns.

• Default: false

Events

onExportSaved

• jQuery Event: export-saved.bs.table

• Parameter: exportedRows

• Detail:

Fired when the data is exported, the parameter contain:

• exportedRows: The exported rows (depends on exportDataType)

Methods

exportTable

• parameters: options

• Detail:

Export table with custom options.

Localizations

formatExport

• Parameter: undefined

• Default: 'Export data'