Hallo,
we do have many Excel sheets (Templates) that contain placeholder values (e.g. {PersName}).
Our goal is to read all the placeholders and replace them with the respective values that are stored in SAP. Therefore, we are trying to find the adresses of all placeholder fields.
However until now we are not able to read values (Get property value of a cell) from the excel sheet.
We also tried to call the method "find" on a range object without success.
Does somebody have some sample code that read the value of a cell and/or searches for cells with a specific content?
Best regards,
Jürgen