Extract text from excel

Hey Community!

I’m looking for a way to extract the plain text from excel. I have this table:


and as you can see, the value in the cell is 26:31:00 but when i select it, the value inside is 01/01/1900 2:31:00 AM.
I just want to extract the 26:31:00 and not the one with the date. I am using the Read Range Activity but so far no luck, I keep getting the value with the date. I also tried the PreserveFormat property for this but still it keeps getting the date.

Can anyone help me with this? It would be such a great help. Thanks in advance!


In my environment, i can get value correctly with Preserve Format option as the following

Ca you share what value did you get and which activity do you use?


1 Like