Getting the shown string from an excel cell

[jacdelad]

Hello,
I'm new to COMatePLUS, but I needed to start with it because I needed to get values from an Excel table. However, I got it to work (using the COMatePLUS package downloaded from RSBasic's website) by using the example provided. Now I have an Excel cell with special formatting ([h]"h"mm"min") and I want to get the content exactly how Excel shows it to me. But reading it with (like all other cells)

Code: Select all

ExcelObject\GetStringProperty("Cells("3,6)")

gives me a string with a float oder double or whatever value. Can I force the command to give me exactly what Excel shows me?

[jacdelad]

Aye, I found it out for my special case, but the question in general remains.