code for read Excel file in C#

 public Microsoft.Office.Interop.Excel.Workbook Open(string Location)

        {

            try

            {

                this.WB = this.APP.Workbooks.Open(Location, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);

                this.WS = this.WS = (Microsoft.Office.Interop.Excel.Worksheet)WB.Sheets[1];

                this.APP.Visible = true;

                // this.WS.Change += APP_SheetChangeEvent;

                //  this.APP.SheetChange += Event_ChangeEvent;

                return this.WB;

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }