c# 选择excel文件，并打开excel

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using Microsoft.Office.Core;

using Excel=Microsoft.Office.Interop.Excel;

using System.Windows.Forms;

using System.Reflection;

 

 

namespace Excelproject

{

    public partial class ExcelForm : Form

    {

         

        private ExcelOperate eo;

        private string excelpath;

        private Excel.Application excel1;

        private Excel.Workbooks wbs = null;

        private Excel.Workbook wb = null;

        private Excel.Sheets  wss;

        private Excel.Worksheet ws = null;

        private Excel.Range range1 = null;

 

 

        public ExcelForm()

        {

            InitializeComponent();

            this.excel1 = new Excel.Application();

            if (excel1 == null)

            {

                MessageBox.Show("error");

                System.Windows.Forms.Application.Exit();

            }

            excel1.Visible = true;

       

        }

 

 

 

        #region excel文件打开关闭操作

        private void 打开_Click(object sender, EventArgs e)

        {

            openFileDialog1 = new OpenFileDialog();

            openFileDialog1.Title = "打开excel文件";

            openFileDialog1.Filter = "excel03文件(*.xls)|*.xls|excel07文件(*.xlsx)|*.xlsx";

            openFileDialog1.InitialDirectory = @"C:\Users\Administrator\Desktop";

            openFileDialog1.RestoreDirectory = true;

            if (openFileDialog1.ShowDialog() == DialogResult.OK)

            {

                //打开文件对话框选择的文件

                excelpath = openFileDialog1.FileName;

                eo = new ExcelOperate();

                readExcel(excelpath);

             

            }

        }

 

        void readExcel(string path)

        {

            object miss = System.Reflection.Missing.Value;

            excel1.UserControl = true;

            excel1.DisplayAlerts = false;

            excel1.Application.Workbooks.Open(excelpath, miss, miss, miss, miss,

                                             miss, miss, miss, miss,

                                             miss, miss, miss, miss,

                                             miss, miss);

            wbs = excel1.Workbooks;

            wss = wbs[1].Worksheets;

            ws = (Excel.Worksheet) wss.get_Item(1);

            int rowNum = ws.UsedRange.Cells.Rows.Count;

            int colNum = ws.UsedRange.Cells.Columns.Count;

            string cellStr = null;

            char ch = 'A';

            for (int i = 0; i < colNum; i++)

            {

                dataGridView1.Columns.Add(i.ToString(), ch.ToString());

                dataGridView1.Rows.Add(rowNum);

                for (int j = 0; j <rowNum; j++)

                {

                    cellStr = ch.ToString() + (j + 1).ToString();

                    dataGridView1[i, j].Value = ws.UsedRange.Cells.get_Range(cellStr, miss).Text.ToString();

                }

                ch++;

            }

 

 

        }

 

        #endregion

 

    }

}