fix: table column style bug and addTable colum type (#2649)

* fix table column style bug and addTable colum type * make TableColumnProperties.style optional
exceljs · Jan 12, 2024 · 5bed18b · 5bed18b
1 parent ddab279
commit 5bed18b
Show file tree

Hide file tree

Showing 3 changed files with 12 additions and 3 deletions.
diff --git a/index.d.ts b/index.d.ts
@@ -1832,6 +1832,11 @@ export interface TableColumnProperties {
 	  * Optional formula for custom functions
 	  */
 	totalsRowFormula?: string;
+
+	/**
+	 * Styles applied to the column
+	 */
+	style?: Partial<Style>;
 }
 
 

diff --git a/lib/doc/table.js b/lib/doc/table.js
@@ -183,7 +183,7 @@ class Table {
     const assignStyle = (cell, style) => {
       if (style) {
         Object.keys(style).forEach(key => {
-          cell[key] = style[key];
+          cell.style[key] = style[key];
         });
       }
     };

diff --git a/test/test-table.js b/test/test-table.js
@@ -1,4 +1,4 @@
-const Excel = require('../lib/exceljs.nodejs.js');
+const Excel = require('../lib/exceljs.nodejs');
 const HrStopwatch = require('./utils/hr-stopwatch');
 
 const [, , filename] = process.argv;
@@ -47,14 +47,18 @@ ws.addTable({
       totalsRowFunction: 'max',
       filterButton: true,
       totalsRowResult: 8,
+      style: {numFmt: '0.00%'},
     },
     {
       name: 'Word',
       filterButton: false,
       style: {font: {bold: true, name: 'Comic Sans MS'}},
     },
   ],
-  rows: words.map((word, i) => [new Date(+today + (86400 * i)), i, word]),
+  rows: words.map((word, i) => {
+    const additionalDays = 86400 * i;
+    return [new Date(today + additionalDays), i, word];
+  }),
 });
 
 const stopwatch = new HrStopwatch();