1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Reflection;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            string connetionString = null;
            OleDbConnection connection;
            OleDbDataAdapter oledbAdapter;
            
             int i;
            connetionString ="Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=U:\\tabelle1.xlsx;" + "Extended Properties=\"Excel 12.0;HDR=NO\";";

 connection = new OleDbConnection(connetionString);

               
            
           //Einlesen der Daten.... 
                connection.Open();
                DataTable dt = new DataTable();
                oledbAdapter = new OleDbDataAdapter("select * from [Sheet1$B:B]",connection);
              oledbAdapter.Fill(dt);

                oledbAdapter.Dispose();
                connection.Close();

            
                
                for (i = 0; i <= dt.Rows.Count - 1; i++)
                {
                                       
                    MessageBox.Show (dt.Rows[i].ItemArray[0] + "" +dt.TableName);
                }
            
            }}}                    

1:
2:
3:
4:
5:

if (!string.IsNullOrEmpty(dt.Rows[i].ItemArray[0].toString())
{
    // gibt nur nicht leere Felder aus
    MessageBox.Show (dt.Rows[i].ItemArray[0] + "" +dt.TableName);
}