昨天,今天,明天,每天的每天,你是否都多懂得一点点...

星期一, 七月 07, 2008

Read excel using c#

create a new c# window application. then, add a datagrid to the form. then do this.
using System.Data.Odbc;
//add code after InitializeComponent();
OdbcConnection con = new OdbcConnection(@"Driver={Microsoft Excel Driver (*.xls)};DBQ=filename.xls");
OdbcCommand cmd = new OdbcCommand(@"SELECT * FROM [Sheet1$]");
cmd.Connection = con;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;



没有评论:

其它博客地址

此博客的同步博客地址: http://fengnz.wordpress.com
这里进入我的MSN SPACE.