Error when using Angular Spreadsheet

610

Jeff Kelso posted over 5 years ago

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

Top Replies

34810

Offline Andrew Goldenbaum posted over 5 years ago in reply to Jeff Kelso +1 verified
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...view reply »
610

Offline Jeff Kelso posted over 5 years ago in reply to Andrew Goldenbaum +1 verified
Thanks for the great example. This is exactly what I'm looking for. Jeff

0

Offline Ari Block posted over 4 years ago in reply to Jeff Kelso

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 })
~~~~~~~~~
Cancel
Reply

Cancel
610

Offline Jeff Kelso posted over 4 years ago in reply to Andrew Goldenbaum

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
Cancel
Reply

Cancel
610

Offline Jeff Kelso posted over 5 years ago in reply to Jeff Kelso

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
Cancel
Reply

Cancel
610

Verified Answer
Offline Jeff Kelso posted over 5 years ago in reply to Andrew Goldenbaum

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

Jeff
Cancel
Reply

Reject Answer

Cancel
34810

Verified Answer
Offline Andrew Goldenbaum posted over 5 years ago in reply to Jeff Kelso

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
Cancel
Reply

Reject Answer

Cancel