Hi Hung,
Your requirement can be accomplished by using hte Desktop Office integration concept(DOI). Follow the below steps:
1. Upload the template to theBDS(Business document server).
2. Create a Document container control instance with reference to the interface I_OI_CONTAINER_CONTROL.
CALL METHOD c_oi_container_control_creator=>get_container_control
IMPORTING
control = gcl_control
error = gcl_error.
3.Create a Container instance with reference to the class CL_GUI_CUSTOM_CONTAINER.
4. Initialize the above created Control instance using the method INIT_CONTROL by passing the Container instance.
5. Create an instance for the document that would like to be opened with reference to the interface I_OI_DOCUMENT_PROXY using the method GET_DOCUMENT_PROXY of the interface I_OI_CONTAINER_CONTROL by passing the document typeu2019.
5.Create an instance for the document maintained in the BDS server with reference to the CL_BDS_DOCUMENT_SET and use the method GET_WITH_URL
7.Use the OPEN_DOCUMENT method of I_OI_DOCUMENT_PROXY to open the required document by passing the above obtained URL..
8. use the method get_spreadsheet_interface of the above document instance and get the interface(i_oi_spreadsheet). Now use the methods of the interface to modify the sheet.
Regards,
Kiran BObbala
Bluesky
