FlexSheet itemsSource

FlexSheet itemsSource

Posted by: productinfo on 9 August 2018, 1:47 am EST

• 

  productinfo

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 August 2018, 1:47 am EST

  How do I get the itemsSource of an excel file imported into FlexSheet?

• 

  productinfo

  • Post Options:
  • Link
    Copy

  Posted 9 August 2018, 6:56 pm EST

  We are importing Excel but writing itemsSource undefined

• 

  productinfo

  • Post Options:
  • Link
    Copy

  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?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  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