There are a few ways to show Excel content in Sharepoint. One of them is creating a list in Excel and publish it to a Sharepoint list. This way, the data stays synchronized which is a nice example of Office integration. Sometimes however, this way is not statisfying because only the data is shown in Sharepoint. Other elements like layout are lost in Sharepoint. in this case there is another way to achieve Excel - Sharepoint integration.
1) First, create or upload an Excel document to a Sharepoint document library
2) And open the document to edit it
3) Then go to 'File -> Save as Web Page'. The file will now be saved as .HTM file in the same document library. Hit 'Save'
3) Now go to the Area on where you want to publish the Excel data (and layout). Choose 'Edit Page' and 'Add Webpart', 'Browse'.
4) Select the Pageviewer webpart and drag it to the page. Open the toolpane to edit the URL.
5) Change the URL to the ExcelSheet.htm file and hit OK
That's it! The Excel content is now displayed on the sharepoint Area.