View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karthikeyan Karthikeyan is offline
external usenet poster
 
Posts: 1
Default Displaying multiline Text into Excel Cell through Interop

Hi,
The scenario is, I have data in SQL server, which needs
to be populated in Excel Sheet through interop. The data
in SQL Server contains new line characters also. I need
to display the text as multiline text into the Excel
Cell. When we just assign the text, the excel engine
renders the new line characters as special characters
(weired character like a square box). Any Solutions..

Thanks in Advance
Karthik