Hi @vimva679 

I suggest you enable the format attribute from Source:

Read formating (.formating)

After you can configure the transformer Tester:

Thanks in Advance,

Danilo

Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

 

 

 

Hi, I did understand the combination now. Please, wait some seconds.

Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

 

 

 

Hi, I did understand the combination now. Please, wait some seconds.

Please - could you share me your input data?

Hello @danilo_fme please find the sample file attached. The text is inconsistent and it changes from file to file. So only common thing is colour of the CELL

Thanks for your data. In a few minutes - you will have the results :)

Hi @vimva679 

Attached the Workspace template developd in FME 2024 version.

Excellent , it works perfectly , thank you so much for great learning. Highly appreciate and obliged with your quick response. I tried it 2022.2 FME version and its works as well . 

Excellent , it works perfectly , thank you so much for great learning. Highly appreciate and obliged with your quick response. I tried it 2022.2 FME version and its works as well . 

 

 

Awesome. I’m happy to help you!

So @danilo_fme please on another know-how does it mean if I want to find or identify if any STRIKED records in Excel sheet,then I type “Strike” in (Right Value )and it would pass entire rows / cell in rows that are striked off i.e. Strike and Not Stiked rows could as well be seperated likewise separating records based on CELL colour? 

Also where can I or which documents on FME could I find such settings or commands please /Br 

Here is some explanation:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm

GOT it right now : STRIKEOUT