Create a master template and use it as requirements.

The following benefits - 

1. View excel workbook in browser.
2. Disable the Cells.
3. The spreadsheet works as an Excel workbook
4. Drop-down for master data.
5. Excel file download.

How to create excel workbook template ?

Open Template List -

Create/Modify Template -

Refer the JQuery Kindo Spreadsheet - https://demos.telerik.com/kendo-ui/spreadsheet/index