C# Operate Excel File

try

{

string s="select * from Name.TableName";

OleDbCommand cmd=new OleDbCommand (s,cn);

OleDbDataReader dr=cmd.ExecuteReader ();

Excel.Application xlApp = new Excel.Application();

if(xlApp==null){MessageBox.Show ("Can't open Excel!");return;}

xlApp.Application .Workbooks .Add (true);

int row=2,fieldcount;

fieldcount=dr.FieldCount ;

for(int col=0;col<fieldcount;col++) xlApp.Cells [1,col+1]=dr.GetName(col);

while (dr.Read ())

{

for(int col=0;col<fieldcount;col++)

xlApp.Cells [row,col+1]=dr.GetValue(col).ToString();

row++;

}

xlApp.Visible =true;

xlApp=null;

}

catch(Exception ex ){MessageBox.Show (ex.Message );}

finally {cn.Close();}

}

catch(Exception ex){MessageBox.Show (ex.Message );}

}

}