I am adding some styling to my exported Excel file using ag-grid, I could change font colors, font size... etc I want the excel file's header to be pinned or fixed while scrolling.

I have checked this article: https://ag-grid.com/angular-data-grid/row-pinning/

but it did not help me much.

here is the styling code.

excelStyles: [
       {
          id: 'header',
          alignment: {
            vertical: 'Center',
            horizontal: 'Center',
          },
          interior: {
            color: '#4472C4',
            pattern: 'Solid',
            patternColor: undefined,
            height: 49,
          },
          font: {
            fontName: 'ＭＳ Ｐゴシック',
            // underline: 'Single',
            italic: false,
            color: '#ffffff',
            size: 14
          },
          borders: {
                borderBottom: {
                    color: "#000000", lineStyle: 'Continuous', weight: 3
                },
                borderTop: {
                    color: "#000000", lineStyle: 'Continuous', weight: 3
                }
            },
        },
],