using Excel = Microsoft.Office.Interop.Excel;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelExample

{

    class Program

    {

        static void Main(string[] args)

        {

            Excel.Application excelApp = new Excel.Application();  // Creates a new Excel Application

            excelApp.Visible = true;  // Makes Excel visible to the user.

            // The following line if uncommented adds a new workbook

            //Excel.Workbook newWorkbook = excelApp.Workbooks.Add();

            // The following code opens an existing workbook

            string workbookPath = "F:\\11.xlsx";  // Add your own path here

            Excel.Workbook excelWorkbook = null;

            try

            {

                excelWorkbook = excelApp.Workbooks.Open(workbookPath, ,

                    false, , "", "", false, Excel.XlPlatform.xlWindows, "", true,

                    false, , true, false, false);

            }

            catch

            {

                //Create a new workbook if the existing workbook failed to open.

                excelWorkbook = excelApp.Workbooks.Add();

            }

            // The following gets the Worksheets collection

            Excel.Sheets excelSheets = excelWorkbook.Worksheets;

            // The following gets Sheet1 for editing

            string currentSheet = "Sheet1";

            Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);

            // The following gets cell A1 for editing

            Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "B1");

            // The following sets cell A1's value to "Hi There"

            excelCell.Value2 = "Hi There";

            Excel.Worksheet excelWorksheet2 = (Excel.Worksheet)excelSheets.get_Item("Sheet2");

            Excel.Range excelCell2 = (Excel.Range)excelWorksheet2.get_Range("A1", Type.Missing);

            excelCell2.Value2 = "Hi Here";

            // Add hyperlinks to the cell A1

            //excelWorksheet.Hyperlinks.Add(excelCell,"http:\\www.baidu.com",Type.Missing,"baidu",Type.Missing);

            // Add hyperlinks from "sheet1 A1" to "sheet2 A1"

            excelWorksheet.Hyperlinks.Add(excelCell, "#Sheet2!A1", Type.Missing, Type.Missing, Type.Missing);

            // Close the excel workbook

            //excelWorkbook.Close(true,Type.Missing,Type.Missing);

            //Quit the excel app

            //excelApp.Quit();

        }

    }

}