How to Read Excel Form Controls Using Power Automate or Office Scripts?
I have an Excel file that contains various Form Controls, such as buttons, checkboxes, and drop-down lists. I need to read the values and states of these Form Controls programmatically using either Power Automate or Office Scripts in an online environment. However, I am unsure about the proper way to access and retrieve the information from these controls. I would like to know the specific steps or methods required to read the Form Control values using these tools.