[Advanced Excel] Problem reading a decimal value

hello :)

I'm using the Advanced Excel extension, and I'm reading a cell in my Excel

When I try to read the cell (Z2) a decimal value with a comma separating the decimal value, the Cell_Read action returns the same value but with a period separating the decimal value,

How do I get the Cell_Read action to return the value with a comma?

thank you very much

Hi, the value of the cell is being read as text (ReadText input parameter is set to True). If you want to keep this behavior, you can easily replace the decimal with a comma by applying the built-in Replace function like so:

Replace(Cell_Read.CellValue, ".", ",")

Hoping to have helped you.

Hello Troy

I want to capture the real value of the cell, when it is a comma I want to capture the comma if there is a point I want to capture the point

Hey João ,

The thing is you have applied ReadText = true but still your code is not working. If Possible can you please provide me a demo OML and excel so that I can investigate the root cause.

Thanks & Regards,

Sudip Pal

hello :)

Thanks a lot for the help

I will share the OML and the excel file

Templates_virgula ponto.xlsx

You have to make ReadText = true.

I hope this will work.

Thanks & Regards, 

Sudip Pal

I did a test even with true it doesn't work

Can you please send me the latest OML ?

Let me check with that.

Thanks & Regards,

Sudip Pal

I have tried with your OML and excel.After making the ReadText = true.It works for me.

Column 25

row 2

Thanks & Regards,

Sudip Pal

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.