customizeCell: Function, // A callback to customize an Excel cell during export.worksheet: Object, // The Excel worksheet into which the PivotGrid will be exported.component: PivotGrid, // A PivotGrid instance.To export a PivotGrid, use the new ExportPivotGrid method (it accepts an object with the following fields): Should you have a specific use-case it does not address, feel free to comment below. This new Excel Export API offers tons of lexibility – we certainly hope it meets all your business requirements. Export any custom content such as images or text.Export your PivotGrids side-by-side with DataGrids.Export as many PivotGrids to a single Excel workbook or worksheet as required.Place the exported PivotGrid at any position within the target Excel Worksheet using the new topLeftCell option.
Create additional worksheets or modify exported worksheets. Since we offer you full control over the exported Excel workbook, a few important use cases can now be implemented within your web app (v20.2): You can use the loadPanel option to customize its display characteristics as needed. To indicate that export is in progress, our Pivot Grid for Angular, Vue, React and jQuery automatically displays a Load Panel. If you’ve exported large datasets, you already know that some web browser may ‘freeze’ until the export process is complete. You can use this range to position your custom header or footer within the document at a location relative to specific PivotGrid data cells. Our new implementation calculates the cell range occupied by the exported PivotGrid and passes it to you in a callback function. With our new Excel Export API, you are not limited to what can be displayed withing headers and footers. Headers and footers are an essential part of many business documents. 
Though most will opt for WYSIWYG export, our API allows you to customize the exported document as needed. The new customizeCell callback gives you total control over exported cell values, display format and associated pivot table appearance within Excel.
Column band settings (multi-level column headers). The new PivotGrid Export to Excel API (for Angular, Vue, React, jQuery) can now automatically apply an expanded list of PivotGrid UI configuration options for the exported Excel document. Let’s take a closer look at what you can expect with our new PivotGrid Excel Export API. This library allows you to customize exported Excel documents as your business requirements dictate. What’s NewĪs you may already know, our new Excel Export API is based on the open source ExcelJS library. Our improved Excel Export API ( first available for the DevExtreme DataGrid) is now part of our PivotGrid component - and available for Angular, Vue, React, and jQuery.
0 kommentar(er)
