Insert data from a CANoe database to an existing Excel sheet

`Recently, I was given a task to automate the process of inserting some data of an ECU in CANoe into an already existing Excel sheet using CAPL. I am fairly new to this and wanted some help. I will be as elaborate as possible.

1. How can I create an link an env var to a database in CAPL/CANoe.
2. I have already creaed a panel with a button that should be assigend with the above asked env var. So, my question here is how can I access an already existing file that needs some data from this button? I mean CAPL does not allow excel format. How can I output some data to an existing excel sheet with the click of a button? How should I proceed to write the code for this?

CAPL has no API to communicate with Excel and/or print to Excel format.

You need to write your library to do it, or use an external script (think a python script, or something else) with a call to SysExec() in your CAPL.

To the best of my knowledge, there isn't an opensource solution ready.