C#读写Excel表格

 /// <summary>
        /// 读取表格
        /// </summary>
        /// <param name="excelPath"></param>
        /// <returns></returns>
        static DataSet ExcelGetDataTable(string excelPath)
        {
            //处理格式
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);

            IExcelDataReader excelReader = null;

            using (FileStream stream = new FileStream(excelPath, FileMode.Open, FileAccess.Read))定义文件流
            {
                //首先判断传入的.xls文件还是xlsx文件
                int index = excelPath.LastIndexOf('.');//获取文件扩展名前‘.’的位置
                string extensionName = excelPath.Substring(index + 1);
                if (extensionName == "xls")
                {
                    //传入的xls文件---->97-2003format
                    excelReader = ExcelReaderFactory.CreateBinaryReader(stream);