Getting the shown string from an excel cell
Posted: Thu May 12, 2022 1:31 pm
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)
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?
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)")