 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Bssoft
Guest
|
 Posted: Mon Sep 19, 2005 3:11 pm Post subject: Excel replace string |
 |
|
Hi all,
I have this code :
ExcelApp.Connect;
ExcelApp.Workbooks.Open('test.xls', EmptyParam, EmptyParam,
EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, 0);
ExcelApp.Visible[0] := True;
ExcelSheet.ConnectTo(ExcelApp.Sheets[1] as _worksheet);
ExcelSheet.UsedRange[0].Replace('#test#', '01/01/2005', xlPart,
xlByRows,
False, False);
My problem is..when i execute string replace...my excel sheet cell
don't maintein cell format, font and other cell properties..How to
solve my problem ?
There is another way to make this ?
Thank's in advanced for answer.
Spank - Italy
|
|
| Back to top |
|
 |
Riki Wiki
Guest
|
| Posted: Sat Sep 24, 2005 11:46 pm Post subject: Re: Excel replace string |
|
|
Hoi
Take a look here:
<http://tinyurl.com/8m5nw>
which links to
<http://delphi.wikicities.com/wiki/Delphi_Newsgroups>
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
