Posted 14 September 2017, 12:00 pm EST
Hi,
we are using Flexsheet with angular 2. After importing an excel sheet to the grid, all the existing functionalities like validations are not working.
Can anyone help to give a solution, if it is possible that the flexsheet could retain all existing features after importing an excel?
we have refereed this below code from wijmo 5 demo, for importing excel.
load () {
var flexSheet = this.flexSheetIntro,
fileInput = <HTMLInputElement>document.getElementById(‘importFile’);
if (flexSheet && fileInput.files[0]) {
flexSheet.load(fileInput.files[0]);
}
}
in html:
<input type=“file” class=“form-control” id=“importFile” accept=“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet” />
<button class=“btn btn-default” (click)=“load()”>Load</button>
Thanks,
Sasmita