private void Test()
        {
            String filename = @"Bob's Data";
            String listname = @"Bob's Data";
 
            OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 8.0");
            
            try
            {
                con.Open();
                DataSet myDataSet = new DataSet();
                OleDbDataAdapter myCommand = new OleDbDataAdapter(" SELECT * FROM [" + listname + "$]", con);
                myCommand.Fill(myDataSet);
                con.Close();
 
                foreach (DataRow myDataRow in myDataSet.Tables[0].Rows)
                {
                    Object[] cells = myDataRow.ItemArray;
                    foreach (object cellContent in cells)
                    {
                        string cellText = cellContent.ToString();
                        cellText = cellText.Replace("\n", "|");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            } 
        }