C#excel与datagridview

C#操作excel显示在dategridview中vs2008

整个过程程序代码如下：

private void 使用App打开Excel_Click(object sender, EventArgs e) {

OpenFileDialog openDG = new OpenFileDialog();

openDG.Title = "打开Excel表格";

openDG.Filter = "Excel表格(*.xls)|*.xls|CSV格式(*.csv)|*.csv|所有文件(*.*)|*.*";

openDG.ShowDialog();

string filename;

filename = openDG.FileName;

object missingValue = System.Reflection.Missing.Value;

Microsoft.Office.Interop.Excel.Application excelApp

= new Microsoft.Office.Interop.Excel.ApplicationClass();

Microsoft.Office.Interop.Excel.Workbook myWorkBook;

excelApp.Workbooks.Open(filename, missingValue, missingValue, missingValue, missingValue, missingValue

, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue);

myWorkBook = excelApp.Workbooks.get_Item(1);

Microsoft.Office.Interop.Excel.Worksheet newSheet;

newSheet =

(Microsoft.Office.Interop.Excel.Worksheet)myWorkBook.Sheets[1]; dataGridView1.Columns.Clear();

int m = 1, n = 1;

Microsoft.Office.Interop.Excel.Range rng1;

while ((rng1 = (Microsoft.Office.Interop.Excel.Range)newSheet.Cells[1, m]).Value2 != null)

{

dataGridView1.Columns.Add("", m.ToString());

m++;

}

m--;

while ((rng1 = (Microsoft.Office.Interop.Excel.Range)newSheet.Cells[n, 1]).Value2 != null)