How to repair Corrupted MS Excel file?

1.Click File >Open.
2.Click the location and folder that contains the corrupted workbook.
3.In the Open dialog box, select the corrupted workbook.
4. Click the arrow next to the Open button, and then click Open and Repair.
5. To recover as much of the workbook data as possible, pick Repair.
If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.

Recover the data from an open workbook
If you face issues while working in an Excel file, you can choose to return to the last saved version of the Excel file. For this:
Click on File. Select Open.
Double click on the name of the workbook (the one that at is open in your Excel)
Click Yes to reopen it.
The workbook will now appear. Please note that you will not have latest modifications in the newly opened document.

I would definitely recommend you to go through this article Recover Permanently Erased Excel Files On Windows. It will help you to guide the best way to recover deleted, corrupted files from the hard drive.