Search and replace

Search and replace

Posted by: pedro.moraes on 23 May 2023, 1:15 pm EST

• 

  pedro.moraes

  • Post Options:
  • Link
    Copy

  Posted 23 May 2023, 1:15 pm EST

  How do I create a search method and a replace method manually?

  I’m using:
  
  search(searchCondition: GC.Spread.Sheets.Search.SearchCondition): GC.Spread.Sheets.Search.SearchResult

  But it always looks only for the first result, I would like to do the search in sequence and the total search.

  And I didn’t find any method to replace it.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 24 May 2023, 2:52 am EST - Updated 24 May 2023, 2:58 am EST

  Hi Pedro,

  Kindly refer to the following sample to find all the occurrences of a searchString. It provides you with foundSheetIndex, foundSheetName, foundRowIndex, foundColumnIndex for all the occurrences.

  “Replace” operation is basically overriding the previous value with new value. Once you get all the occurrences (total search), you can do the sequencing and use the setValue() method to replace the text or iterate through all the occurrences and replace the value using the setValue() method to perform “Replace All” operation.

  Sample: https://jscodemine.grapecity.com/share/YJvRK33RDEiqF2TiH5kCFg/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"]%2C"ActiveFile"%3A"%2Findex.html"}

  You could also refer to the following demo that finds all the occurrences sequentially: https://www.grapecity.com/spreadjs/demos/features/workbook/search#demo_source_name

  Kindly let us know if you face any problems or require further assistance in this matter.

  API References:

  setValue method: https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#setvalue

  getSheet method: https://www.grapecity.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Workbook#getsheet

  getSheetFromName method: https://www.grapecity.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Workbook#getsheetfromname

  Regards,

  Ankit