jQWidgets jqxDataTable exportSettings属性

  • Post category:jquery

以下是关于“jQWidgets jqxDataTable exportSettings属性”的完整攻略,包含两个示例说明:

简介

jqxDataTable 控件提供了 exportSettings 属性,该属性用于配置表格导出的设置,包括导出格式、文件名、表头、表尾等。

详细攻略

以下是 jqxDataTable 控件的 exportSettings 属性的详细攻略:

exportSettings属性

exportSettings 属性用于配置表格导出的设置,包括导出格式、文件名、表头、表尾等。

“`javascript
$(“#jqxdatatable”).jqxDataTable({
exportSettings: {
columnsHeader: true,
hiddenColumns: true,
serverURL: ‘export.php’,
characterSet: null,
recordsInView: true,
fileName: ‘jqxDataTable’,
contentType: ‘application/octet-stream’,
header: null,
footer: null,
exportData: null,
rows: null,
columns: null,
exportServer: false,
url: null,
format: ‘xlsx’,
filter: null,
pageMargin: null,
landscape: false,
autoFit: false,
worksheetName: null,
style: null,
rowsHeight: null,
columnsWidth: null,
cellsMerge: null,
cellsFormat: null,
cellsAlignment: null,
cellsVerticalAlignment: null,
cellsWrap: null,
cellsPadding: null,
cellsBorder: null,
cellsFont: null,
cellsBackground: null,
cellsForeground: null,
cellsStyle: null,
cellsConditionalFormatting: null,
cellsNumberFormat: null,
cellsDateFormat: null,
cellsTimeFormat: null,
cellsDateTimeFormat: null,
cellsCurrencyFormat: null,
cellsPercentageFormat: null,
cellsScientificFormat: null,
cellsCustomFormat: null,
cellsFormula: null,
cellsHyperlink: null,
cellsComment: null,
cellsValidation: null,
cellsDataValidation: null,
cellsConditionalValidation: null,
cellsProtection: null,
cellsMergeAcross: null,
cellsMergeDown: null,
cellsMergeEqual: null,
cellsMergeCustom: null,
cellsMergeStyles: null,
cellsMergeCallback: null,
cellsMergeRange: null,
cellsMergeRangeStyles: null,
cellsMergeRangeCallback: null,
cellsUnmerge: null,
cellsUnmergeStyles: null,
cellsUnmergeCallback: null,
cellsUnmergeRange: null,
cellsUnmergeRangeStyles: null,
cellsUnmergeRangeCallback: null,
cellsInsert: null,
cellsInsertStyles: null,
cellsInsertCallback: null,
cellsDelete: null,
cellsDeleteStyles: null,
cellsDeleteCallback: null,
cellsCopy: null,
cellsCut: null,
cellsPaste: null,
cellsPasteValues: null,
cellsPasteFormats: null,
cellsPasteFormulas: null,
cellsPasteComments: null,
cellsPasteValidation: null,
cellsPasteHyperlinks: null,
cellsPasteMerge: null,
cellsPasteInsert: null,
cellsPasteDelete: null,
cellsPasteShift: null,
cellsPasteCallback: null,
cellsUndo: null,
cellsRedo: null,
cellsReset: null,
cellsResetStyles: null,
cellsResetCallback: null,
cellsPrint: null,
cellsPrintStyles: null,
cellsPrintCallback: null,
cellsExport: null,
cellsExportStyles: null,
cellsExportCallback: null,
cellsValidationList: null,
cellsValidationListCallback: null,
cellsValidationListData: null,
cellsValidationListDataCallback: null,
cellsValidationListDataUrl: null,
cellsValidationListDataUrlCallback: null,
cellsValidationListDataJson: null,
cellsValidationListDataJsonCallback: null,
cellsValidationListDataXml: null,
cellsValidationListDataXmlCallback: null,
cellsValidationListDataCsv: null,
cellsValidationListDataCsvCallback: null,
cellsValidationListDataTsv: null,
cellsValidationListDataTsvCallback: null,
cellsValidationListDataExcel: null,
cellsValidationListDataExcelCallback: null,
cellsValidationListDataPdf: null,
cellsValidationListDataPdfCallback: null,
cellsValidationListDataHtml: null,
cellsValidationListDataHtmlCallback: null,
cellsValidationListDataText: null,
cellsValidationListDataTextCallback: null,
cellsValidationListDataArray: null,
cellsValidationListDataArrayCallback: null,
cellsValidationListDataFunction: null,
cellsValidationListDataFunctionCallback: null,
cellsValidationListDataObject: null,
cellsValidationListDataObjectCallback: null,
cellsValidationListDataObservable: null,
cellsValidationListDataObservableCallback: null,
cellsValidationListDataPromise: null,
cellsValidationListDataPromiseCallback: null,
cellsValidationListDataAsync: null,
cellsValidationListDataAsyncCallback: null,
cellsValidationListDataSync: null,
cellsValidationListDataSyncCallback: null,
cellsValidationListDataLocal: null,
cellsValidationListDataLocalCallback: null,
cellsValidationListDataRemote: null,
cellsValidationListDataRemoteCallback: null,
cellsValidationListDataServer: null,
cellsValidationListDataServerCallback: null,
cellsValidationListDataClient: null,
cellsValidationListDataClientCallback: null,
cellsValidationListDataCustom: null,
cellsValidationListDataCustomCallback: null,
cellsValidationListDataFilter: null,
cellsValidationListDataFilterCallback: null,
cellsValidationListDataSort: null,
cellsValidationListDataSortCallback: null,
cellsValidationListDataGroup: null,
cellsValidationListDataGroupCallback: null,
cellsValidationListDataAggregate: null,
cellsValidationListDataAggregateCallback: null,
cellsValidationListDataPivot: null,
cellsValidationListDataPivotCallback: null,
cellsValidationListDataTree: null,
cellsValidationListDataTreeCallback: null,
cellsValidationListDataChart: null,
cellsValidationListDataChartCallback: null,
cellsValidationListDataMap: null,
cellsValidationListDataMapCallback: null,
cellsValidationListDataGantt: null,
cellsValidationListDataGanttCallback: null,
cellsValidationListDataScheduler: null,
cellsValidationListDataSchedulerCallback: null,
cellsValidationListDataSpreadsheet: null,
cellsValidationListDataSpreadsheetCallback: null,
cellsValidationListDataDiagram: null,
cellsValidationListDataDiagramCallback: null,
cellsValidationListDataReport: null,
cellsValidationListDataReportCallback: null,
cellsValidationListDataDashboard: null,
cellsValidationListDataDashboardCallback: null,
cellsValidationListDataForm: null,
cellsValidationListDataFormCallback: null,
cellsValidationListDataGrid: null,
cellsValidationListDataGridCallback: null,
cellsValidationListDataTreeGrid: null,
cellsValidationListDataTreeGridCallback: null,
cellsValidationListDataKanban: null,
cellsValidationListDataKanbanCallback: null,
cellsValidationListDataPivotGrid: null,
cellsValidationListDataPivotGridCallback: null,
cellsValidationListDataSchedulerTimeline: null,
cellsValidationListDataSchedulerTimelineCallback: null,
cellsValidationListDataSchedulerAgenda: null,
cellsValidationListDataSchedulerAgendaCallback: null,
cellsValidationListDataSchedulerMonth: null,
cellsValidationListDataSchedulerMonthCallback: null,
cellsValidationListDataSchedulerWeek: null,
cellsValidationListDataSchedulerWeekCallback: null,
cellsValidationListDataSchedulerDay: null,
cellsValidationListDataSchedulerDayCallback: null,
cellsValidationListDataSchedulerResource: null,
cellsValidationListDataSchedulerResourceCallback: null,
cellsValidationListDataSchedulerCalendar: null,
cellsValidationListDataSchedulerCalendarCallback: null,
cellsValidationListDataSchedulerGantt: null,
cellsValidationListDataSchedulerGanttCallback: null,
cellsValidationListDataSchedulerTimelineDay: null,
cellsValidationListDataSchedulerTimelineDayCallback: null,
cellsValidationListDataSchedulerTimelineWeek: null,
cellsValidationListDataSchedulerTimelineWeekCallback: null,
cellsValidationListDataSchedulerTimelineMonth: null,
cellsValidationListDataSchedulerTimelineMonthCallback: null,
cellsValidationListDataSchedulerTimelineYear: null,
cellsValidationListDataSchedulerTimelineYearCallback: null,
cellsValidationListDataSchedulerTimelineDecade: null,
cellsValidationListDataSchedulerTimelineDecadeCallback: null,
cellsValidationListDataSchedulerTimelineCentury: null,
cellsValidationListDataSchedulerTimelineCenturyCallback: null,
cellsValidationListDataSchedulerTimelineMillennium: null,
cellsValidationListDataSchedulerTimelineMillenniumCallback: null,
cellsValidationListDataSchedulerTimelineCustom: null,
cellsValidationListDataSchedulerTimelineCustomCallback: null,
cellsValidationListDataSchedulerTimelineWorkWeek: null,
cellsValidationListDataSchedulerTimelineWorkWeekCallback: null,
cellsValidationListDataSchedulerTimelineHoliday: null,
cellsValidationListDataSchedulerTimelineHolidayCallback: null,
cellsValidationListDataSchedulerTimelineBusinessHours: null,
cellsValidationListDataSchedulerTimelineBusinessHoursCallback: null,
cellsValidationListDataSchedulerTimelineNonWorkingTime: null,
cellsValidationListDataSchedulerTimelineNonWorkingTimeCallback: null,
cellsValidationListDataSchedulerTimelineWorkingTime: null,
cellsValidationListDataSchedulerTimelineWorkingTimeCallback: null,
cellsValidationListDataSchedulerTimelineLunchTime: null,
cellsValidationListDataSchedulerTimelineLunchTimeCallback: null,
cellsValidationListDataSchedulerTimelineBreakTime: null,
cellsValidationListDataSchedulerTimelineBreakTimeCallback: null,
cellsValidationListDataSchedulerTimelineMeetingTime: null,
cellsValidationListDataSchedulerTimelineMeetingTimeCallback: null,
cellsValidationListDataSchedulerTimelineAppointmentTime: null,
cellsValidationListDataSchedulerTimelineAppointmentTimeCallback: null,
cellsValidationListDataSchedulerTimelineEventTime: null,
cellsValidationListDataSchedulerTimelineEventTimeCallback: null,
cellsValidationListDataSchedulerTimelineTaskTime: null,
cellsValidationListDataSchedulerTimelineTaskTimeCallback: null,
cellsValidationListDataSchedulerTimelineProjectTime: null,
cellsValidationListDataSchedulerTimelineProjectTimeCallback: null,
cellsValidationListDataSchedulerTimelineCustomTime: null,
cellsValidationListDataSchedulerTimelineCustomTimeCallback: null,
cellsValidationListDataSchedulerTimelineTimezone: null,
cellsValidationListDataSchedulerTimelineTimezoneCallback: null,
cellsValidationListDataSchedulerTimelineDaylightSavingTime: null,
cellsValidationListDataSchedulerTimelineDaylightSavingTimeCallback: null,
cellsValidationListDataSchedulerTimelineStandardTime: null,
cellsValidationListDataSchedulerTimelineStandardTimeCallback: null,
cellsValidationListDataSchedulerTimelineLeapYear: null,
cellsValidationListDataSchedulerTimelineLeapYearCallback: null,
cellsValidationListDataSchedulerTimelineLeapMonth: null,
cellsValidationListDataSchedulerTimelineLeapMonthCallback: null,
cellsValidationListDataSchedulerTimelineLeapDay: null,
cellsValidationListDataSchedulerTimelineLeapDayCallback: null,
cellsValidationListDataSchedulerTimelineLeapHour: null,
cellsValidationListDataSchedulerTimelineLeapHourCallback: null,
cellsValidationListDataSchedulerTimelineLeapMinute: null,
cellsValidationListDataSchedulerTimelineLeapMinuteCallback: null,
cellsValidationListDataSchedulerTimelineLeapSecond: null,
cellsValidationListDataSchedulerTimelineLeapSecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapMillisecond: null,
cellsValidationListDataSchedulerTimelineLeapMillisecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapMicrosecond: null,
cellsValidationListDataSchedulerTimelineLeapMicrosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapNanosecond: null,
cellsValidationListDataSchedulerTimelineLeapNanosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapPicosecond: null,
cellsValidationListDataSchedulerTimelineLeapPicosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapFemtosecond: null,
cellsValidationListDataSchedulerTimelineLeapFemtosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapAttosecond: null,
cellsValidationListDataSchedulerTimelineLeapAttosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapZeptosecond: null,
cellsValidationListDataSchedulerTimelineLeapZeptosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapYoctosecond: null,
cellsValidationListDataSchedulerTimelineLeapYoctosecondCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckTime: null,
cellsValidationListDataSchedulerTimelineLeapPlanckTimeCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfTime: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfTimeCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfTime: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfTimeCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckLength: null,
cellsValidationListDataSchedulerTimelineLeapPlanckLengthCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfLength: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfLengthCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfLength: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfLengthCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckMass: null,
cellsValidationListDataSchedulerTimelineLeapPlanckMassCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfMass: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfMassCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfMass: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfMassCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckCharge: null,
cellsValidationListDataSchedulerTimelineLeapPlanckChargeCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfCharge: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfChargeCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfCharge: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfChargeCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckTemperature: null,
cellsValidationListDataSchedulerTimelineLeapPlanckTemperatureCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfTemperature: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfTemperatureCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfTemperature: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfTemperatureCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckEnergy: null,
cellsValidationListDataSchedulerTimelineLeapPlanckEnergyCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfEnergy: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfEnergyCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfEnergy: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfEnergyCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckForce: null,
cellsValidationListDataSchedulerTimelineLeapPlanckForceCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfForce: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfForceCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfForce: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfForceCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckPressure: null,
cellsValidationListDataSchedulerTimelineLeapPlanckPressureCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfPressure: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfPressureCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfPressure: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfPressureCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckEnergyDensity: null,
cellsValidationListDataSchedulerTimelineLeapPlanckEnergyDensityCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfEnergyDensity: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfEnergyDensityCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfEnergyDensity: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfEnergyDensityCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckPower: null,
cellsValidationListDataSchedulerTimelineLeapPlanckPowerCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfPower: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfPowerCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfPower: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfPowerCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckVelocity: null,
cellsValidationListDataSchedulerTimelineLeapPlanckVelocityCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfVelocity: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfVelocityCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfVelocity: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfVelocityCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckAcceleration: null,
cellsValidationListDataSchedulerTimelineLeapPlanckAccelerationCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfAcceleration: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfAccelerationCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfAcceleration: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfAccelerationCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckMomentum: null,
cellsValidationListDataSchedulerTimelineLeapPlanckMomentumCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfMomentum: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfMomentumCallback: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfMomentum: null,
cellsValidationListDataSchedulerTimelineLeapNaturalUnitOfMomentumCallback: null,
cellsValidationListDataSchedulerTimelineLeapPlanckAngularMomentum: null,
cellsValidationListDataSchedulerTimelineLeapPlanckAngularMomentumCallback: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfAngularMomentum: null,
cellsValidationListDataSchedulerTimelineLeapAtomicUnitOfAngularMomentumCallback: null,
cellsValidation