Repeat column headers in Pivot Table custom PDF export

[GUU]

I am using the following configuration, but I don't see any way to repeat the columns header on each page.

let pdfExportProperties = {

            fileName: this.props.fileName + '.pdf' || 'pivot_table.pdf',

            pageOrientation: 'Landscape',

            header: {

                fromTop: 0,

                height: 20,

                contents: [

                    {

                        type: 'Text',

                        value: (this.props.pdfTitle || 'Pivot Table') + moment(new Date()).format('DD-MM-YYYY HH:mm:ss'),

                        position: {x: 0, y: 0},

                        style: {textBrushColor: '#000000', fontSize: 15, dashStyle: 'Solid', hAlign: 'Center'},

                    },

                ],

            },

            footer: {

                fromBottom: 0,

                height: 20,

                contents: [

                    {

                        type: 'PageNumber',

                        pageNumberType: 'Arabic',

                        format: '{$current} of {$total}',

                        position: {x: 0, y: 0},

                        style: {textBrushColor: '#02007a', fontSize: 13},

                    },

                ],

            },

        }

        this.pivotObj.pdfExport(pdfExportProperties)

[Manikandan Murugesan]

Hi Gonzalo, 

 

To repeat the column headers on each page, please enable the "repeatHeader" property in the "pdfHeaderQueryCellInfo" event. Please see the code example below. 

Code Example: 

            <PivotViewComponent 

              gridSettings={{ 

                pdfHeaderQueryCellInfo: this.pdfHeaderQueryCellInfo.bind(this), 

              }} 

            > 

            </PivotViewComponent>   

 

pdfHeaderQueryCellInfo(args) { 

    args.cell.row.pdfGrid.repeatHeader = true; 

  } 

Meanwhile, we have prepared a sample for your reference. Please find it from below link. 

Sample: https://stackblitz.com/edit/react-q2nhpd 

Please let us know if you have any concerns. 

Regards, 

Manikandan 

[GUU]

Thanks it worked.

[Manikandan Murugesan]

Hi Gonzalo, 

   

Please let us know if you have any other queries. We are always happy to assist you.  

   

Regards,  

Manikandan