How to add a breakline inside a cell with Excel4node module in NodeJs

Question

I need to insert a multiline cell with module excel4node, in documentation I didn't found anything about this. I tried to insert the escape sequence "\n" but it didn't work. This is my code:

var xl = require('excel4node');
var wb = new xl.Workbook();
var ws = wb.addWorksheet('Sheet 1');

ws.cell(1, 1).string('first line \n second line');

And this is the result inside the cell:

first line \n second line

Somebody knows how it's possible to insert a multiline cell? Which char must I use?

score 7 · Accepted Answer · answered Mar 10 '20 at 14:33

7

My friendo

Have you tried this way?

ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');

answered Mar 10 '20 at 14:33

Zoz

86
2

score 3 · Answer 2 · answered Mar 10 '20 at 14:40

3

I've encountered this problem some time ago. I resolved with:

ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');

answered Mar 10 '20 at 14:40

Dragneel Larcade

31
2

score 3 · Answer 3 · edited Mar 10 '20 at 16:32

3

Helped a colleague yesterday who was having the same issue, after a while we came up with this solution.

ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');

edited Mar 10 '20 at 16:32

DharmanBot

1,066
2
6
10

answered Mar 10 '20 at 15:02

Dalfstep

41
3

score 3 · Answer 4 · answered Mar 15 '21 at 22:32

3

I use this to insert breaklines

ws.cell(row, col).string('text to print \n another line').style({ alignment: { wrapText: true});

answered Mar 15 '21 at 22:32

Daniel Rojas Rodriguez

31
2

score 0 · Answer 5 · edited Jul 07 '21 at 12:53

0

There are many ways. I hope this could help. By this code, you can also format a specific line

var complexstring = [
  'line1\n',
  {
    bold: true,
    size: 7,
    name: 'Arial',
    italics: true,
    value: 'line2'
  }
]
ws.cell(4, 2).string(complexstring)

edited Jul 07 '21 at 12:53

Josef

2,869
2
22
23

answered Jul 06 '21 at 03:58

sonjasan

49
5

score 0 · Answer 6 · answered Nov 29 '21 at 08:48

0

I've tried alignment and it works

const style = ws.createStyle({
  alignment: {
    wrapText: true,
  },
})
ws.cell(4, 2).string('new\nline').style(style)

answered Nov 29 '21 at 08:48

Alexander Bladyko

1

How to add a breakline inside a cell with Excel4node module in NodeJs

6 Answers6