I have a requirement where Users have to view uploaded excel files on a site running on an intranet, NB the files themselves must be hosted locally. Solutions I have looked at include.
The option 2 can be achieved because you can host WOPI client on-premise.
https://learn.microsoft.com/en-us/officeonlineserver/deploy-office-online-server