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 TroyI 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
You have to make ReadText = true.
I hope this will work.
I did a test even with true it doesn't work
Can you please send me the latest OML ?
Let me check with that.
I have tried with your OML and excel.After making the ReadText = true.It works for me.
Column 25
row 2