Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings
How can I draw tables with Ms Excel e Vba?
Thank you. I will try.You can have a look at how to use API to communicate with router and send your queries to receive the needed data:
https://help.mikrotik.com/docs/display/ROS/API
There is also some example using Python, which has lot of functions to manage Excel and PDF files:
https://help.mikrotik.com/docs/display/ ... n3+Example
There is also REST-API that you can check:
https://help.mikrotik.com/docs/display/ROS/REST+API
Yes.Personally I have never used API approach as I mostly do all my stuffs with script directly on router.
However one thing you could also check is, if it fits your needs, an easy way to generate a sort of CSV file generated with a ROS script after that you have gathered the user information that you are looking for.
I'm not used to user management topics, so I don't know what options you have, but whatever can be scripted, then you can save such data directly to a file in CSV and then use Excel to import such file directly some way.
Options are there, you can choose the best for you.