c#读取Excel

1、下载微软官方提供的操作Excel的dll，Microsoft.Office.Interop.Excel.dll

2、添加该dll到引用

3、直接上代码

using System.Reflection;using Excel = Microsoft.Office.Interop.Excel;using System.Xml;using System.IO;using System.Collections;namespace ReadExcel{        class Program    {         static void Main(string[] args)        {              
                string excelFileName="test.xls";                object miss = Missing.Value;                Excel.Application ea = new Excel.Application();                               Excel.Workbook ew = ea.Workbooks.Open(base_path + @"\" + excelFileName, miss, miss, miss, miss, miss, miss);                //选择sheet1                Excel.Worksheet es = (Excel.Worksheet)ew.Worksheets[1];               // 选定读取范围               Excel.Range er = es.get_Range("A2", "K448");                            //定义二位数组存储文本                string[,] myparam = new string[447, 12];               for (int i = 1; i < 448; i++)              {                    for (int j = 1; j < 13; j++)                    {                        myparam[i - 1, j - 1] = ((Excel.Range)er.Cells[i, j]).Text.ToString();                         Console.Write(myparam[i - 1, j - 1] + ",");                                            }                    Console.WriteLine();                   // progressBar.Dispaly((Convert.ToInt32((i / (448 * 1.0)) * 100)));               }                ea.Workbooks.Close();                ea.Quit();                System.Runtime.InteropServices.Marshal.ReleaseComObject(ea);                ea = null;                System.GC.Collect();
}}}