PC Review


Reply
Thread Tools Rate Thread

C# Excel Replace text in a range

 
 
boyan.mihailov@gmail.com
Guest
Posts: n/a
 
      31st Jan 2007
Hi all! I am using C# to access Excel. I have the following situation.

I have a cell with the following text: "Some text {a} and another text
{b}"
I want to replace {a} and {b} with a specific string and this string
to be with a specific Font. I am using get_characters to change the
font only for these characters. But when I replace {b} and change the
font of its replacement, the other text font in the cell is set to
default (including the replacement of {a}). My question is how can I
workaround this problem? How can I replace {a} and {b} and change the
font of their replacement?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to Excel - Replace a Range Ross Microsoft Access External Data 2 7th Mar 2008 12:55 PM
C# Excel Replace text in a range boyan.mihailov@gmail.com Microsoft Excel Programming 0 31st Jan 2007 08:07 PM
replace a range of #'s e.g. 1.25 to 100 with text in excell =?Utf-8?B?UGFpbnRlcg==?= Microsoft Excel Worksheet Functions 1 27th Dec 2005 08:36 PM
Can't replace a text in the range (Word automation with Office XPInterop assemblies) Pekka Microsoft C# .NET 0 27th Jun 2005 07:01 PM
automatic replace excel cell/range? simplething Microsoft Excel Misc 1 9th Sep 2003 10:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:36 AM.