Part of the security is to disable data populated in a table to be exported to excel files.
Any idea if this is possible and how ?
It's possible using security rules.
The ExportAppData rule is the default rule. You can disable this rule and create your own, or disable wholesale.
Any idea if you can apply the security rule on specific application objects or its applied on Apps and sheets objects
the rule is set up as an App rule. There is no capability to restrict export on specific objects. Perhaps sheets, but I don't think so.
I think it's only available at the app level for Governance purposes.
Retrieving data ...