Import Excel to Multirow Grid

Posted by: germiep.fernandez on 11 January 2022, 2:11 pm EST

    • Post Options:
    • Link

    Posted 11 January 2022, 2:11 pm EST - Updated 3 October 2022, 3:10 am EST

    Hi,

    I am trying to import the file I’ve exported from the grid, but there is a problem in rendering the columns of the grid.

    This is the initial look of the grid:

    And after importing the excel file, it became like this:

    What should I do to fix this? The columns are not multirow.

    I’ve upload the sample file, this file is from exporting from the same grid.

    And this is the code for importing the excel file

    
    uploadExcel(): void {
        const layout = this.grid.columnLayout;
        const fileInput = this.import.nativeElement;
        if(fileInput.files[0]) {
          wjGridXlsx.FlexGridXlsxConverter.loadAsync(this.grid, fileInput.files[0], { includeColumnHeaders: true });
        }
      }
    
  • Posted 11 January 2022, 2:13 pm EST - Updated 3 October 2022, 3:11 am EST

    This is the sample excel contents

  • Posted 12 January 2022, 12:02 am EST

    Hello,

    We apologize but excel importing isn’t supported in multiRow control due to the layout complexity. Sorry for the inconvenience.

    Regards

  • Posted 12 January 2022, 10:50 pm EST

    I see, noted on that. Thank you.

Need extra support?

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

Learn More

Forum Channels