shuanhukexuejia
commented
1 year ago Need to convert images from object to array at present
LuckyExcel.transformExcelToLuckyByUrl(`/repo/api/doc/${document.id}/download`, document.name + document.extension,
(exportJson) => {
if (exportJson.sheets == null || exportJson.sheets.length == 0) {
this.notificationsService.notify(NotificationLevel.ERROR, this.translate.instant('Document.Excel.InvalidDocument'))
return;
}
// convert images to array
exportJson.sheets.forEach((sheet: any) => {
if (sheet.images) {
sheet.images = Object.entries(sheet.images).map(([key, value]) => {
return { id: key, src: value.src, ...value.default };
});
}
}
const options = {
showFormulaBar: true,
showToolbar: false,
showSheetTabs: true,
data: exportJson.sheets,
allowEdit: false,
lang: this.translate.getDefaultLang()
};
const root = createRoot(this.elementRef.nativeElement);
root.render(React.createElement(ExcelReactComponent, options));
nicoesiea
gazedreamily
Describe the bug When there is an image in the file, the component is not rendered and there is an error message in the console (see screenshots section): Uncaught TypeError: _context$insertedImgs.map is not a function and VM1933 react_devtools_backend.js:2655 The above error occurred in the component:
Here is the code I use in the angular constructor to load the file and render it:
Expected behavior View the Excel file with the image attached inside the table
Screenshots
Additional context "@fortune-sheet/core": "^0.15.3", "@fortune-sheet/react": "^0.15.3", "luckyexcel": "^1.0.1", "react": "^18.0.2", "react-dom": "^18.2.0"