workbook cannot be opened when trying to integrate office web app in mvc

Question

I have been following this tutorial to open office web apps online but when I click URL generated by selecting the excel file I get error

workbook cannot be opened

you may test here to check the issues

Discovery.xml file is taken from HERE production environment and code is hosted on my own server

Answer 1

You can't just take the discovery file from the WOPI docs. As the docs say:

These URLs are publicly accessible. However, you will not be able to invoke any WOPI actions successfully unless your WOPI domain has been added to the WOPI domain allow list.

The discovery file contains URLs to a working WOPI client instance. This needs to be either Office Online with your domain added to white-list or an on-premise instance of the Office Online Server. Here's how to install it locally. Then, fetch the discovery file from your instance.