How to displays an Excel workbook in a page as webpart in sharepoint

• An Excel Access Web Part is a SharePoint technology that displays an Excel workbook from a document library

What is an Excel Web Access Web Part?

A workbook in an Excel Web Access Web Part is very similar in appearance and behavior to a workbook in Microsoft Excel. For example, a workbook in an Excel Web Access Web Part can have sheet tabs, outline buttons, and drop-down arrows. There are several ways to customize the Web Part.

Add an Excel Web Access Web Part to a page

This procedure describes the specific steps that you have to take to add an Excel Web Access Web Part to an existing Web Part page. To add a Web Part to a page, you must belong to the default <Site Name> Members SharePoint group for the site.

If no appropriate page exists, you might have to create a site page.

To add an Excel Web Access Web Part to a Web Part page, follow these steps.

1. From the Web Part page where you want to add an Excel Web Access Web Part, locate the Web Part zone that you want to use. In the zone, click Add a Web Part. .

1. The following illustration shows an example of a newly created Web Part page. The page contains a Header zone and one Body zone. Each zone contains the Add a Web Part box.
2. In the zone where you want to add the Excel Web Access Web Part, click Add a Web Part to display the Create dialog box.
3. In the Create dialog box, select Excel Web Access. Then, click Add.
   This adds the Web Part to the page and displays the Select a Workbook pane.

Connect a workbook to a Web Part

1. In the Excel Web Access Select a Workbook pane, click the link Click here to open the tool pane. The page changes to Edit mode, and displays the Excel Web Access tool pane.

1.  In the Workbook Display section in the Workbook text box, enter the URL or UNC of the workbook. If you do not know the URL, you can click the browse button, and then select the workbook that you want to use.
2. In the Toolbar and Title Bar section and in the Navigation and Interactivity section, select one or more properties that you want to enable. If you want to disable a property, clear the associated check box.

To save changes and exit Web Part Edit mode, you can click OK at the bottom of the Web Part tool pane. Or, to stop editing and view the workbook in Display mode, click Stop Editing.

This displays the Web Part that you configured to use its associated workbook on the page.

Refer:https://support.office.com/en-us/article/introduction-to-excel-web-access-web-part-21f18464-1f2f-4acb-bcdc-14d0ba451a1c