composize
diff --git a/‎packages/excel/src/dsl.spec.ts
Lines changed: 22 additions & 1 deletion b/‎packages/excel/src/dsl.spec.ts
Lines changed: 22 additions & 1 deletion
diff --git a/‎packages/excel/src/dsl.ts
Lines changed: 15 additions & 2 deletions b/‎packages/excel/src/dsl.ts
Lines changed: 15 additions & 2 deletions
@@ -1,4 +1,4 @@
-import { borderedCell, cell, row, workbook, worksheet } from './dsl';
+import { borderedCell, cell, centeredCell, row, workbook, worksheet } from './dsl';
 
 describe('Excel DSL', () => {
 
@@ -241,4 +241,25 @@ describe('Excel DSL', () => {
     expect(createdCell.border?.bottom?.style).toBe('thin');
     expect(createdCell.border?.right?.style).toBe('thin');
   });
+
+  it('should create a centered cell with thin borders and centered alignment', () => {
+    const book = workbook(() => {
+      row(() => {
+        centeredCell('centered', { numFmt: '0.00%' });
+      });
+    });
+
+    const sheet = book.worksheets[0];
+    const createdCell = sheet.getRow(1).getCell(1);
+
+    expect(createdCell.value).toBe('centered');
+    expect(createdCell.numFmt).toBe('0.00%');
+    expect(createdCell.border?.top?.style).toBe('thin');
+    expect(createdCell.border?.left?.style).toBe('thin');
+    expect(createdCell.border?.bottom?.style).toBe('thin');
+    expect(createdCell.border?.right?.style).toBe('thin');
+    expect(createdCell.alignment?.horizontal).toBe('center');
+    expect(createdCell.alignment?.vertical).toBe('middle');
+  });
+
 });
@@ -81,7 +81,7 @@ export type CellOptions = Partial<{ colSpan: number, rowSpan: number } & Pick<Ce
 /**
  * Creates and configures a cell within the current worksheet at the current row and column position.
  *
- * @param value The value to be placed into the cell. Can be of any type supported by exceljs.
+ * @param value The value to be placed into the cell.
  * @param options Optional configuration for the cell.
  * @returns The `exceljs.Cell` object that was created and configured.
  */
@@ -124,7 +124,7 @@ export function cell(value: any, options: CellOptions = {}) {
 /**
  * Creates a cell object with a thin border applied to all four sides.
  *
- * @param value - The value to be placed into the cell. Can be of any type supported by exceljs.
+ * @param value - The value to be placed into the cell.
  * @param options - Optional configuration for the cell.
  * @returns The `exceljs.Cell` object that was created and configured.
  */
@@ -140,6 +140,19 @@ export function borderedCell(value: any, options: CellOptions = {}) {
   })
 }
 
+/**
+ * Creates a cell configuration with content centered horizontally and vertically.
+ *
+ * @param value - The value to be placed into the cell.
+ * @param options - Optional configuration for the cell.
+ */
+export function centeredCell(value: any, options: CellOptions = {}) {
+  return borderedCell(value, {
+    alignment: { horizontal: 'center', vertical: 'middle' },
+    ...options
+  });
+}
+
 const DEFAULT_FONT_SIZE = 11;
 const DEFAULT_COL_WIDTH = 8.43;