본문 바로가기

C#

C# OleDb Excel to DataGridView Open

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);
	}
}