Comedian and actress Caroline Aherne, best known for Mrs Merton and The Royle Family has died after battling cancer.