访问excel

string filename = @"D:/cc.xls"; Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook; Microsoft.Office.Interop.Excel.Worksheet worksheet; object oMissing = System.Reflection.Missing.Value; workbook = excel.Workbooks.Open(filename, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing); worksheet = (Worksheet)workbook.Worksheets[1]; int rowCount = worksheet.UsedRange.Rows.Count; int colCount = worksheet.UsedRange.Columns.Count; Microsoft.Office.Interop.Excel.Range range1; System.Data.DataTable dt = new System.Data.DataTable(); for (int i = 0; i < colCount; i++) { range1 = worksheet.get_Range(worksheet.Cells[1, i + 1], worksheet.Cells[1, i + 1]); if (range1.Value2 != null) { dt.Columns.Add(range1.Value2.ToString()); } } for (int j = 1; j < rowCount; j++) { DataRow dr = dt.NewRow(); for (int i = 0; i < colCount; i++) { range1 = worksheet.get_Range(worksheet.Cells[j + 1, i + 1], worksheet.Cells[j + 1, i + 1]); if (range1.Value2 != null) { dr[i] = range1.Value2.ToString(); } } dt.Rows.Add(dr); } GridView1.DataSource = dt; GridView1.DataBind();