1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

        private void öffnenToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "Exceldatein (*.xls)|*.xls";/*Filter nur xls "Exceldatein"*/
            ofd.ShowDialog();

            if (ofd.ShowDialog() == DialogResult.OK)
            { 
                try
                {
                    StreamReader sr = new StreamReader(ofd.FileName);
                    sr.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Texteditor");
                }

            }
        }                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

private void öffnenToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();
            openFileDialog1.Filter = "Excelfile (*.xls)|*.xls|Alle Dateien (*.*)|*.*";
            openFileDialog1.ShowDialog(); 

            
            string DateiName = openFileDialog1.FileName.Substring(3).ToString();
            

            String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= " + DateiName + ";" + "Extended Properties=Excel 8.0;";

            DataSet ds = new DataSet(strConn);
            OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Kontoauszug$]", strConn);

            da.Fill(ds, "Table");
            dataGridView1.DataSource = ds.Tables[0].DefaultView;

        }