x
ActiveReportsJS v5.2 is Here! Check out our newest update. ActiveReportsJS v5.2 is Here! ARJS 5.2 is Here!

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

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

    • Post Options:
    • Link

    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

  • 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

  • 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

  • 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

  • Posted 14 September 2017, 12:00 pm EST

    Hi Abhishek,

    Any update on this?

    Thanks,

    Sasmita

  • 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

  • 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

  • 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels