How to Make \n Line Breaks Work in ExcelJS

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27import ExcelJS from 'exceljs';

export default function ExcelText(
  worksheet: ExcelJS.Worksheet,
  cell: string,
  text: string,
  fontSize: number,
  vertical: any,
  horizontal: any,
  color: string = '',
  bold: boolean = false,
) {
  const cellRef = worksheet.getCell(cell);

  // Add the text
  cellRef.value = {
    richText: [
      {
        text: text,
        font: { size: fontSize, bold, color: { argb: color } },
      },
    ],
  };

  // Apply the styles
  cellRef.alignment = { vertical, horizontal };
}

1
2
3
4
5
6
7
8
9
10ExcelText(
    worksheet,
    `F${40 + itemLength}`,
    `3F, HANDOK BLDG., 2645, NAMBUSUNHWAN-RO, \nGANGNAM-GU, SEOUL, 06271, SOUTH KOREA`,
    10,
    'middle',
    'left',
    '',
  );
  worksheet.getCell(`E${40 + itemLength}`).alignment = { wrapText: true };