I am generating a CSV file using PHP and opening it in Excel. Adding "\ n" at the end of each record creates a new row and works perfectly, but I need to find a way to create a new line within a cell. Enter the same functionality manually data into Excel When doing alt + enter is received. Does anyone know how this can be done? I have tried "\ n \ r", "\ n", chr (10), none of which seems to work, just keep getting a whole new line instead of the new line within a single cell .
Do I want to receive it, is a header that looks like this ... it's all in Excel in the same line.
Cell
Start Date End Date
Thanks for providing any help!
How are you making a CSV file? Again it is done correctly and using a fputcsv , there is no problem with having a line break inside the cell.
No comments:
Post a Comment