CollectionView getting null after import data through excel

CollectionView getting null after import data through excel

Posted by: satyamurthy.rada on 5 June 2020, 11:22 am EST

• 

  satyamurthy.rada

  • Post Options:
  • Link
    Copy

  Posted 5 June 2020, 11:22 am EST

  Hi Team,

  I am binding getError method to collectionView initially.

  data =  new wjcCore.CollectionView([],{
      getError: ()=>{
        console.log('test');
      }
    });
  

  After importing data through excel, I am loosing the getError method.

  Is there any way I can retain or bind it again to collectionView so that I can show error for invalid cell?

  Thanks.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2020, 12:54 am EST

  Hi

  While importing an excel file, we do not know whether the excel’s data can be converted to a JSON data which can be bound to the flexgrid. That is why we do not create a collectionview after importing. You will need to manually create the data by iterating over each row and column and then assign this data to the sourceCollection of the already created collectionview. Please refer to the sample link below:

  https://stackblitz.com/edit/angular-ktce63

  Regards,
  
  Ashwin