Kindly suggest which new line character supports both Excel and XML
we have a code which takes data from database , generate XML using Cognos and creates Xls.
In the excel, in one cell, we need the data to be displayed in multiple cells.
ex. if you put your address in one cell in excel, it should display as
Leena
House no 2
City
Ctry
right now it is getting displayed in one single line 'LeenaHouse no 2CityCtry'
please suggest
thanks
Bookmarks