C#

public static DataSet Method()
{
    string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILE_PATH;Extended Properties=""Excel 8.0;HDR=YES;""";

    OleDbConnection conn = new OleDbConnection(connectionString);
    OleDbCommand cmd = new OleDbCommand("Select * from [Project List$]", conn);
    cmd.CommandType = CommandType.Text;
    OleDbDataAdapter myAdapter = new OleDbDataAdapter(cmd);
    DataSet ds = new DataSet();

    try
    {
        myAdapter.Fill(ds);
        return ds;
    }
    catch(OleDbException ex)
    {
        throw ex;
    }
}