I am using ABAP2XLSX in my project. This amazing tool has been doing wonders for me.
I have a requirement to populate a particular cell with dropdown values. I can see program ZDEMO_EXCEL45 for the same.
As seen above, if the dropdown list is less than 254 characters long, I can use the logic in this demo program. In my case, the dropdown is QUITE long. I have to show around 25 records in view V_TE453 which contains the Calorific value and its description as a dropdown.
I am not able to find any other demo program for dropdown. Also searching the abap2xlsx GitHub didn't show much results related to the dropdown.
In case you have implemented abap2xlsx in your project, can you please let me know how you achieved dropdown functionality in a cell?