The column heading format is not working in export excel sheet. #3032

New Issue

proraheelaslam · 2023-11-23T12:04:19Z

proraheelaslam commented

2023-11-23 12:04:19 +00:00

Hi,
I am trying to add formation on column heading(background and text color) in excel sheet when click the Export to Excel button. It is not working in exported excel file. The table made in HTML table tags.I tried different ways but these methods are not working.

This script is not working

 // Get header cells
           const headerCells = table.querySelectorAll('th');

          // Set blue background color for header cells
           headerCells.forEach((cell, index) => {
            const cellRef = XLSX.utils.encode_cell({ c: index, r: 0 });
             ws[cellRef].s = { fill: { bgColor: { rgb: 'FF0072C6' } }, font: { color: { rgb: 'FFFFFFFF' } } };
          });

I have made the JS fiddle example please check.
https://jsfiddle.net/3nob5yv8/4/

Thanks

Hi, I am trying to add formation on column heading(background and text color) in excel sheet when click the **Export to Excel** button. It is not working in exported excel file. The table made in HTML table tags.I tried different ways but these methods are not working. This script is not working ``` // Get header cells const headerCells = table.querySelectorAll('th'); // Set blue background color for header cells headerCells.forEach((cell, index) => { const cellRef = XLSX.utils.encode_cell({ c: index, r: 0 }); ws[cellRef].s = { fill: { bgColor: { rgb: 'FF0072C6' } }, font: { color: { rgb: 'FFFFFFFF' } } }; }); ``` I have made the JS fiddle example please check. https://jsfiddle.net/3nob5yv8/4/ Thanks

sheetjs commented

2024-09-02 04:19:03 +00:00

Cell styling is a feature of SheetJS Pro Basic. We may introduce it to SheetJS CE but the timeline is unclear.

Cell styling is a feature of [SheetJS Pro Basic](https://sheetjs.com/pro/). We may introduce it to SheetJS CE but the timeline is unclear.

sheetjs closed this issue

2024-09-02 04:19:03 +00:00

Sign in to join this conversation.