You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 22, 2022. It is now read-only.
I've found this tricky way to insert new line in a cell with excel4node. ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');
But when the cell has more than 255 characters, the cell content disappeared.
Though I can split the text and use CONCATENATE, but is there an more elegant way to insert a long piece of text with new line?
The text was updated successfully, but these errors were encountered:
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
I've found this tricky way to insert new line in a cell with excel4node.
ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');
But when the cell has more than 255 characters, the cell content disappeared.
Though I can split the text and use
CONCATENATE
, but is there an more elegant way to insert a long piece of text with new line?The text was updated successfully, but these errors were encountered: