text bold in excel

Dear DXL users,
I want to copy some text to an excel using a string buffer
I used all the suggested characters : "\b text"
"\\b text"
"\b text \0b"
"\bold text"
richText "{\\b text}"
But the text is copied as it is plain text
So I'm I doing sth wrong?

Thanks And have a nice day
DXL - Mon Jul 05 08:36:49 EDT 2010

Re: text bold in excel
Mathias Mamsch - Tue Jul 06 01:39:20 EDT 2010

Looking at your other post, where you try to write a comma or tab separated file -> you cannot do it like that. CSV or TSV don't support richtext formatting, if you save an excel file with bold text to csv, your formatting will get lost.

Therefore you need to use COM automation, to format the cells in your excel sheet. This is done by setting the Font.bold property on a range object.

Regards, Mathias


Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS