Error when using Angular Spreadsheet

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://ko.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://ko.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,

Jeff

Any updates on my posts?  A Stackblitz example would be very helpful.

Jeff

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://ko.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

Thanks for the great example.  This is exactly what I'm looking for.

Jeff

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.

 

Jeff

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.

Jeff

I just upgraded to lastest Angular and the sample code and

IgxSpreadsheetComponent is not working use the step by step on 

https://ko.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet_overview.html

getting this error 

ERROR in ./src/supplier-rfq/supplier-rfq.component.ts
Module not found: Error: Can't resolve 'ExcelUtility' in 'C:\Code\emsforest\src\supplier-rfq'

ERROR in src/supplier-rfq/supplier-rfq.component.ts:11:30 – error TS2307: Cannot find module 'ExcelUtility'.

11 import { ExcelUtility } from 'ExcelUtility';
~~~~~~~~~~~~~~
src/supplier-rfq/supplier-rfq.component.ts:32:4 – error TS2304: Cannot find name 'ViewChild'.

32 @ViewChild("spreadsheet", { read: IgxSpreadsheetComponent })
~~~~~~~~~