I am trying to create a JSON file by getting data from a macro enabled Excel file which has radio buttons and checkboxes. Can anyone tell me if MS provides any API to do so or how I can do it otherwise.
0
votes
Microsoft exposes excel functionality to all of its languages. Just the tip of the iceberg is, say, docs.microsoft.com/en-us/office/vba/api/excel.windows. That was just a quick internet search. You can use C/C++/VBA/C#/PowerShell/Python and etc... Unfortuantely this is far off of what stackoverflow is about. Good luck!
– tdelaney
Actually, I wanted it in python. This is VB.
– pranab moharana