04-14-2014 8:06 AM
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
04-14-2014 9:08 AM
Have you tried the methods like GET_RANGES_DATA, SET_RANGES_DATA of class
i_OI_SPREADSHEET INTERFACE ?
Thanks
Abhinab
04-14-2014 9:08 AM
Have you tried the methods like GET_RANGES_DATA, SET_RANGES_DATA of class
i_OI_SPREADSHEET INTERFACE ?
Thanks
Abhinab
04-15-2014 9:32 AM
Thanks very much with these methods we resolved the problems.
Best regards Jürgen
04-14-2014 9:37 AM
we are not able to read values (Get property value of a cell)
Can you post your already written code, so we may understand your exact problem ?
You could also use scn search tool and/or analyze some standard codes like FM ALSM_EXCEL_TO_INTERNAL_TABLE or other reports using OLE2 to get a good idea on method to call. Also record some macros in Excel and analyze the generated VBA code.
Regards,
Raymond
04-15-2014 9:33 AM