Posted 9 August 2018, 1:47 am EST
How do I get the itemsSource of an excel file imported into FlexSheet?
Forums Home / Wijmo / General Discussion
Posted by: productinfo on 9 August 2018, 1:47 am EST
Posted 9 August 2018, 1:47 am EST
How do I get the itemsSource of an excel file imported into FlexSheet?
Posted 9 August 2018, 6:56 pm EST
We are importing Excel but writing itemsSource undefined
Posted 9 August 2018, 7:22 pm EST
i need get itemsSource after import excel file, but itemsSource is null after import process. What i resolve this problem?
Posted 9 August 2018, 10:25 pm EST
Hi,
When flexsheet loads an excel file, it is loaded as an unbound sheet hence it does not have binding for itemsSource.
However, if you would like to get all of the sheet’s data then you may use getCellData()/getCellValue() method and generate a data array for the sheet.
Please refer to the following sample which implements the same:-
https://stackblitz.com/edit/angular-hgsrhd?file=app%2Fapp.component.ts
~Manish