.NET操作Excel

如果你新建一個項目的話，首先要添加Microsoft.Office.Core 與Microsoft.Office.Interop.Exce這兩個應用，然后就能很方便的操作了，示例代碼（只實現了簡單的讀寫）：

private Excel._Application excelApp;  
private Workbook wbclass;  

excelApp = new Excel.Application();  

object objOpt = System.Reflection.Missing.Value;  

wbclass = (Workbook)excelApp.Workbooks.Open("E:\Book6.xlsx", objOpt, false, objOpt, objOpt, objOpt, true, objOpt, objOpt, true, objOpt, objOpt, objOpt, objOpt, objOpt);

得到所有的表名：

 List<string> list = new List<string>();
            Excel.Sheets sheets = wbclass.Worksheets;
            string sheetNams = string.Empty;
            foreach (Excel.Worksheet sheet in sheets)
            {
                list.Add(sheet.Name);
            }

 獲取某個表中的數據，這里獲取的是sheet 表中的：

public Excel.Worksheet GetWorksheetByName(string name)  
        {  
            Excel.Worksheet sheet = null;  
            Excel.Sheets sheets = wbclass.Worksheets;  
            foreach (Excel.Worksheet s in sheets)  
            {  
                if (s.Name == name)  
                {  
                    sheet = s;  
                    break;  
                }  
            }  
            return sheet;  
        }  

        public System.Data.DataTable GetDateTable(string name)  
        {  
            System.Data.DataTable dt = new System.Data.DataTable();  

            var worksheet = GetWorksheetByName(name);      //調用上面的方法，利用表名得到這張表  

            string cellContent;  

            int iRowCount = worksheet.UsedRange.Rows.Count;  
            int iColCount = worksheet.UsedRange.Columns.Count;  
            Excel.Range range;  
            for (int iRow = 1; iRow <= iRowCount; iRow++)  
            {  
                DataRow dr = dt.NewRow();  

                for (int iCol = 1; iCol <= iColCount; iCol++)  
                {  
                    range = (Excel.Range)worksheet.Cells[iRow, iCol];  

                    cellContent = (range.Value2 == null) ? "" : range.Text.ToString();  

                    if (iRow == 1)  
                    {  
                        dt.Columns.Add(cellContent);  
                    }  
                    else  
                    {  
                        dr[iCol - 1] = cellContent;  
                    }  
                }  

                if (iRow != 1)  
                    dt.Rows.Add(dr);  
            }  

            return dt;  

        }  

上面得到的只是 

System.Data.DataTable   

如何把數據取出來，請看下面：

    var dataTable = GetDateTable("Sheet1");   //調用上面的方法  

               foreach (DataRow row in dataTable.Rows)  
               {       
                   string a = (string)row[2];  
                   string b = (string)row[4];  

    }