new line character in the cell value

[jimiwhite1020]

New lines in the cell value is not working when you open it via excel. It said all new lines characters should be replaced with like this:

<Cell><Data ss:Type="String">Thank you for your message. Thanks,</Data></Cell>

[ideiasfrescas]

@jimiwhite1020

Below the line that reads

$item = str_replace(''', ''', htmlspecialchars($item, ENT_QUOTES));

add this:

$item = str_replace("\r\n", '
', $item);