How to create a CSV (Excel) sheet with multiple lines in a single cell?
807580Dec 28 2009 — edited Dec 28 2009Hi,
I need to create an Excel sheet in which one of the cells has multiple lines in it.
My initial approach was to create a CSV file, use Comma as a delimiter and hoped that the \n would get picked up within the same cell but that didn't fly well. It shows up on a different line. I even added quotes to the beginning and end of the record (when writing using Java) to see if I could specify the whole thing as a record but that didn't work either.
I have something like this where the Address has multiple lines:
Name, Address, Phone Number
Could anyone advice how to approach this to create an Excel spreadsheet (or CSV file)
Thanks,
Edited by: desimunda on Dec 28, 2009 8:22 AM