I am in the process of capturing the rules we have employed in our workbooks. Worksheet info gives the details of rules but not column names. all i could see is column 1:= (formula). Is there a way to get the column names of a workbook easily. currently I add the worksheet to a new workbook, take a sample of 10 rows and then download them to get the column names which is quite tedious for many work books.
Appreciate if there is a simpler solution. I am not familiar with Rest API etc and i am not the admin as well.
suggest a suitable option. Thanks in advance
Please sign in to leave a comment.