Hi,
I'm receiving the following build error when trying in incorporate Angular Spreadsheet into my project:
ERROR in ./node_modules/igniteui-angular-spreadsheet/ES5/IGExcelSerializationProvider_SyncZipFile.js
Module not found: Error: Can't resolve 'uzip/UZIP' in 'D:\Work\Git\PMISG\IntradayUI\node_modules\igniteui-angular-spreadsheet\ES5'
I installed the prerequisites:
npm install igniteui-angular-core npm install igniteui-angular-excel npm install igniteui-angular-spreadsheet
I don't see any samples on your site for this functionality. That usually helps a lot.
Thanks in advance,
Jeff
Adding more of a narrative; I'm trying to upload a .xlsx file either to an Angular Spreadsheet like in the example of your site:
https://es.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet_overview.html
I'd could also use the Excel Library Framwork similar to the example:
https://es.infragistics.com/products/ignite-ui-angular/angular/components/excel_library.html
The goal is to take the data in the spreadhseet and load it to a database.
Are either of these examples available on Stackblitz?
Thanks,
Any updates on my posts? A Stackblitz example would be very helpful.
I just upgraded to lastest Angular and the sample code and
Hi Andrew, I'm upgraded from Angular 7 to 9 and having difficulties with the excel functionality. Is there any chance you could provide me with an updated spreadsheet.zip project you provided to me several months ago?
Thanks in advance.
Hi Andrew,
When I went to implement your sample into my code I got the same UZIP error I was getting before. I noticed that you're using 7.2.1-beta.1 of the Angular Spreadsheet in your sample while I'm using 7.2.3. The problem occurs in the node_modules\igniteui-angular-spreadsheet\ES5\IGExcelSerializationProvider_SyncZipFile.js file that's not in the beta version. There's a reference to UZIP. There's a peer dependency in the node_modules\igniteui-angular-spreadsheet\packages.json for "uzip": "^0.0.0"; however, doesn’t seem like this got installed. I installed this globally and now everything is now working. Thanks again for your help.
Thanks for the great example. This is exactly what I'm looking for.
Hello Jeff,
I apologize for the delay in a response to this thread.
Currently, the Excel samples that are in our documentation are not yet available on StackBlitz. From the error you are seeing, though, it does sound like you are missing a dependency – potentially to the igniteui-angular package.
While we do not have a StackBlitz example, I do have a working igx-spreadsheet example locally that resembles the sample shown here, just without the updated layout and styling: https://es.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet_configuring.html. I am attaching this sample here. You should just be able to run npm install and ng serve and it should run normally.
I hope this helps. Please let me know if you have any other questions or concerns on this matter.
spreadsheet.zip