You need to trigger change detection tp-detection to update the sheet:
import { Component, OnInit, Inject, ChangeDetectorRef } from '@angular/core';
constructor(private changeDetectorRef: ChangeDetectorRef) { }
ngOnInit() {
this.yourService.getData().subscribe(data => {
// do your stuff and notify of changes like this
this.changeDetectorRef.detectChanges();
});
}