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 });
}
}