How do I import an excel (.xls or .xlsx) file automatically in C#?

See more:

C#

Visual-Studio

VS2017

Hello,

I want to import an excel file in my program automatically.

At the moment, I can import a PDF and with that I have a path given for an excel file, that gets imported and shows the data in TextBoxes.

What I want now is that every time I import a PDF file, I want the program/application to automatically search for an Excel file (.xls or .xlsx) in the Debug folder and import it.

Regards
Aman Chaurasia

What I have tried:

Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            Excel.Range range;

            //string str;
            int rCnt;
            int cCnt;
            int rw = 0;
            int cl = 0;

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open(@"C:\Test\Text.xlsx");
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            range = xlWorkSheet.UsedRange;
            rw = range.Rows.Count;
            cl = range.Columns.Count;

            for (rCnt = 2; rCnt <= rw; rCnt++)
            {
                for (cCnt = 1; cCnt <= cl; cCnt++)
                {
                    TitleTextBox.Text = (string)(range.Cells[2, 1] as Excel.Range).Value2;
                    PublisherTextBox.Text = (string)(range.Cells[2, 2] as Excel.Range).Value2;
                    FileNameTextBox.Text = (string)(range.Cells[2, 3] as Excel.Range).Value2;
                    IssueTextBox.Text = (string)(range.Cells[2, 4] as Excel.Range).Value2;
                    ReleaseDateTextBox.Text = (string)(range.Cells[2, 5] as Excel.Range).Value2;
                    PageCountTextBox.Text = Convert.ToString((range.Cells[2, 6] as Excel.Range).Value2);
                }
            }

            xlWorkBook.Close(true, null, null);
            xlApp.Quit();
        }