Set WrapText attribute for named Range Object using OWC

K

Karthikeyan

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 using OWC. When we just assign the text, the excel engine
renders the new line characters as special characters
(weired character like a square box). Please let me know how to retain WrapText attribute of a Cell using OWC. Any Solutions..

Thanks in Advance
Karthik
 
Top