C#引用的com组件读取Excel的方法

1、引用的com组件：Microsoft.Office.Interop.Excel.dll   读取EXCEL文件

            OpenFileDialog openFile = new OpenFileDialog();
            openFile.Title = "请选择需要导入的Excel文件";
            openFile.Filter = "Excel文件(*.xlsx;*.xls)|*.xlsx;*.xls";
            openFile.RestoreDirectory = false;
            if (openFile.ShowDialog() == DialogResult.OK)
            {
                string path = openFile.FileName;
                object missing = System.Reflection.Missing.Value;
                Application excel = new Application();
                excel.Visible = false;
                excel.UserControl = true;
                //以只读的形式打开EXCEL文件
                Workbook wb = excel.Application.Workbooks.Open(path, missing, true, missing, missing, missing, missing, missing, missing, true, missing, missing, missing, missing, missing);
                //取得第一个工作薄
                Worksheet ws = (Worksheet)wb.Worksheets.get_Item(1);
                //取得总记录行数
                //得到行数
                int rowsint = ws.UsedRange.Cells.Rows.Count;
                //取得数据范围区域
                Range rng1 = ws.Cells.get_Range("A1", "K" + rowsint);
                object[,] arryItem = (object[,])rng1.Value2;
                //数据处理
                
                excel.Quit();
                GC.Collect();
            }