Read Excel file

gistfile1.txt

        private static void Read()
        {
            var fileName = string.Format(@"c:\temp\test.xlsx");
            var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName);

            var adapter = new OleDbDataAdapter("SELECT * FROM [Tabelle1$]", connectionString);
            var ds = new DataSet();

            adapter.Fill(ds, "myDs");

            var data = ds.Tables["myDs"].AsEnumerable();
            foreach (var row in data)
            {
                Console.WriteLine(string.Format("1: {0}, 2: {1}.", row[0], row[1]));
            }
        }