[Advanced Excel] Cell_Write And Cells_FindByValue

Forge Component
(49)
Published on 13 Aug (4 days ago) by Hanno
49 votes
Published on 13 Aug (4 days ago) by Hanno

Hi

1 Can i write a formula in the cell? like( =A1+B2)


2 SyntaxEditor Code Snippet

Cells_FindByValue

 Number cannot be finded.

 Can I add a fuzzy query?


Best regards,

Ri

Hi LI

1. No. The equals sign should be outside the parenthesis

2. The find is matching on exact value. What value are you searching for? If the cells contain formulas, you might need to call Worksheet_Calculate before doing a Cells_FindByValue

Can you elaborate on what you mean by "Fuzzy Query"?

Hanno

Hanno wrote:

Hi LI

1. No. The equals sign should be outside the parenthesis

2. The find is matching on exact value. What value are you searching for? If the cells contain formulas, you might need to call Worksheet_Calculate before doing a Cells_FindByValue

Can you elaborate on what you mean by "Fuzzy Query"?

Hanno


Hi Hanno:


1.I made a formula, please refer to the picture below for the result.

 The result is not a sum.


2. I want to look up words in which a piece of text.

    Example:PrinterColor ,ScribaSmall,ColorPrinter

   Query with color,the result contains PrinterColor and ColorPrinter.

Best regards

For 1. you should set CellType to "formula"

for 2. I believe the search looks for any cell where the specified text occurs as part of the content, not an exact match as I incorrectly mentioned earlier.

Hanno wrote:

For 1. you should set CellType to "formula"

for 2. I believe the search looks for any cell where the specified text occurs as part of the content, not an exact match as I incorrectly mentioned earlier.


Hi Hanno,

Thanks