How to replace strings in sheet?

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
tedylee
Posts: 3
Joined: Sat Jan 19, 2019 11:35 am

How to replace strings in sheet?

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: How to replace strings in sheet?

Post by larsa »

Hello

To read or write cell values, use:

Code: Select all

XLS[0].AsString[Col,Row] := 'replace string';
Lars Arvidsson, Axolot Data
Post Reply