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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC being blocked by McAfee HIPs 1
Retrieve member values for filters in OWC pivot table 0
Displaying multiline Text into Excel Cell through Interop 5
2007 AutoFit, WrapText, fails 1
Reading an Excel file using OWC 1
Word wrap with OWC excel 1
OWC Spreadsheet and SpreadsheetML 2
OWC Spreadsheet events do crash IE6 5

Top