I have an Excel file and it has Checkboxes in a certain column. I need to know the value of each Checkbox under this column. Since this Excel file has a bit data table, I am going to use Read Range.
It seems like this Checkbox is made from Developer Tab > Insert > Checkbox.
When I just used Read Range, it returns a blank/empty string, and I cannot get the value of whether there is a check or not.
How can I do this with Read Range?
I found some documents for similar questions, but they are all talking about checkboxes in Word. Mine is specifically for Excel.
Sample Excel file:
Checkbox.xlsx (12.4 KB)