C# - Excel 창 접근하기

Application -> Books -> Book -> Sheets -> Sheet  순으로 설정 

        private void button1_Click(object sender, EventArgs e)

        {

            string filename = "C:\\test.xlsx";

            object missing = System.Reflection.Missing.Value;

            Excel.Application EApp;

            Excel.Workbook EBook; 

            Excel.Workbooks EBooks;

            Excel.Sheets ESheets;

            Excel._Worksheet ESheet;

            EApp = new Excel.Application();

            EApp.Visible = false;

            EBooks = EApp.Workbooks;

            EBook = EApp.Workbooks.Open(filename, missing, missing, missing, missing, missing, missing

                , missing, missing, missing, missing, missing, missing, missing, missing);

            ESheets = EBook.Worksheets;

            ESheet = (Excel._Worksheet)ESheets.get_Item(1);

//         Range 설정 해줘야 함 

.

.

.

.

.

.

.

.

.

.

.

.

.

.

//아래 적어주면 지금 작업중인(filename에 해당하는) 엑셀 창이 뜬다.

                EApp.Visible = true;

                EApp.UserControl = true;

}