Page 1 of 1

How to replace strings in sheet?

Posted: Sun May 12, 2019 6:31 am
by tedylee
how can I replace some strings to another in sheet(s) or cells, eg., do replace "this cell value" to "replaced string"?
I can't find anything from this forum or Web.

Re: How to replace strings in sheet?

Posted: Mon May 13, 2019 1:19 pm
by larsa
Hello

To read or write cell values, use:

Code: Select all

XLS[0].AsString[Col,Row] := 'replace string';