Flexsheet- on Import of excel, the Flexsheet functionalities are not working

Flexsheet- on Import of excel, the Flexsheet functionalities are not working

Posted by: sasmita-swain2014 on 14 September 2017, 12:00 pm EST

• 

  sasmita-swain2014

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  skochan

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:00 pm EST

  Hi,

  Thank you for your query, could you please share the Excel File that you are trying to load. We will try to investigate this further.

  Thanks,
  
  Abhishek

• 

  sinoliu

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:00 pm EST

  Hi Abhishek,

  Please find attached screenshots that showing before and after import excel.

  Before import: the flexsheet has dropdowns,checkbox and some validations.
  
  after importing excel file: the dropdowns,checkbox are going off.

  Thanks,
  
  Sasmita
  
  

  

• 

  skochan

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:00 pm EST

  Hi,

  These are known issues while loading Excel Sheets into FlexSheet. We already have cases that have been assigned to the dev team for the same. I shall add you as correspondent to these cases and let you know once I have further updates.

  For tracking purposes please note the Case ID’s for future reference

  200820- Importing CheckBox to Excel
  
  253594-Provide ability to Import & export all the drop down options

• 

  sinoliu

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:00 pm EST

  Hi Abhishek,

  Any update on this?

  Thanks,
  
  Sasmita

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:00 pm EST

  Hello Sasmita,
  
  These issues are still with our development team, we will let you know as soon as we get any update on this.

  Thanks,
  
  Manish Kumar Gupta

• 

  bhati.bhati

  • Post Options:
  • Link
    Copy

  Posted 13 June 2019, 9:42 am EST

  Hello Guys,

  I am also facing the same issue. After importing my excel file formatting of header row goes away and drop downs are also not visible. Is there any update on this?

  Thanks
  
  Deepak Bhati

• 

  sara.siddiqui

  • Post Options:
  • Link
    Copy

  Posted 13 June 2019, 3:02 pm EST

  Yes please update on this or if there is some other workaround to get it working after import?

  Thanks,
  
  Sara