Сайн байна уу? Бяцхаан коод
Хэрэг болж магад гэж бодлоо.

using System.Data.OleDb;

public void loadFromExcel()
{
OleDbDataAdapter oleDA;
DataSet ds;
string ConnectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FilePathName@;Persist Security Info=True;Extended Properties=EXCEL 8.0″;

using (OleDbConnection conn = new OleDbConnection(ConnectionString))
{
conn.Open();

oleDA = new OleDbDataAdapter(“select * from [sheetname$]“, conn);

ds = new DataSet();

oleDA.Fill(ds);

dt = ds.Tables[0];

this.gridControl1.DataSource = dt;
}