Query #2: Can the above be done dynamically at runtime too? like clicking a button and that would add the dropdownlist to a column within the sheet. Please provide an example.
We have checked your reported requirement and we would like to let you know that your requirement can be achievable by using cellType support in spreadsheet. For more details, please refer the below CellType demo sample Link,