OpenFileDialog _Ofd = new OpenFileDialog();
_Ofd.Filter = "Excel File (*.xlsx)|*.xlsx";
if (_Ofd.ShowDialog() == DialogResult.OK)
{
string _Path = OpenFilePathName = _Ofd.FileName;
try
{
string _StrConn = "Provider = Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + _Path + ";Mode=ReadWrite|Share Deny None;" +
"Extended Properties='Excel 12.0 XML;HDR=YES;IMEX=1';";
using (OleDbConnection _OleConn = new OleDbConnection(_StrConn))
{
_OleConn.Open();
string _StrCmd = @"SELECT * FROM[Sheet1$]";
OleDbCommand _OleCmd = new OleDbCommand(_StrCmd, _OleConn);
OleDbDataAdapter _Adapter = new OleDbDataAdapter(_OleCmd);
DataSet _DSet = new DataSet();
_Adapter.Fill(_DSet);
dataGridView1.DataSource = _DSet.Tables[0].DefaultView;
if (_OleConn.State == ConnectionState.Open)
{
_OleConn.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
C#