pivot table in spreadsheet

[saravanan]

Hi,

I want to use pivot table functionality in spreadsheet. is it achievable in syncfusion or any other solution is available?

[Madhan Venkateshan]

Hi Saravanan, 

 

Thank you for contacting Syncfusion support. 

 

We would inform you that currently we does not have pivot table support in our EJ2 spreadsheet. We have considered this as an improvement in our end and it will be included in any of our upcoming release and appreciate your patience until then. Please follow the below feedback link, 

 

Feedback Link:  

https://www.syncfusion.com/feedback/12651/pivot-table-support-in-ej2-spreadsheet 

 

Please get back to us if you need further assistance. 

 

Regards, 

Madhan V 

[saravanan]

Hi Saravanan, 

 

Thank you for contacting Syncfusion support. 

 

We would inform you that currently we does not have pivot table support in our EJ2 spreadsheet. We have considered this as an improvement in our end and it will be included in any of our upcoming release and appreciate your patience until then. Please follow the below feedback link, 

 

Feedback Link:  

https://www.syncfusion.com/feedback/12651/pivot-table-support-in-ej2-spreadsheet 

 

Please get back to us if you need further assistance. 

 

Regards, 

Madhan V 

Hi,

thanks for your reply 

I'm trying to load API response to dataSource in the spreadsheet in e-rangesetting but it is not loading. I tried exactly what was given in documentation but that was also not working. only if I try to import the excel then only data is loading in the spreadsheet. I have attached my code here.

thanks 

Attachment: spreadsheet_b6d05cca.zip

[Arunkumar Devendiran]

Hi Saravanan, 

 

We have checked your reported query in that you are trying to dynamically set the data to the spreadsheet by using datasource property. We suspect that you are tried to set the data like two way binding (changing the 'data' property in AppComponent class need to updated in Spreadsheet). We would inform you that currently, we does not have this support on our spreadsheet. We have considered this as improvement in our end and this support will be included in any of our upcoming release. However, we have provided the workaround for your reported scenario, in that we have rendered the spreadsheet when data loaded by setting the ngIf as true. In this way, you can achieve your requirement. Please refer the below sample link. 

 

Sample link: 

https://stackblitz.com/edit/angular-z3bhrc-zpaa63?file=app.component.ts 

 

Please follow the below feedback link. 

https://www.syncfusion.com/feedback/9684/dynamic-data-binding-support 

 

Regards, 

Arunkumar D   

[saravanan]

Actually my angular version was in 9 and I downgraded it to angular 8 then I tried local data binding is working and also your suggestion is also working. 

but I want to have it in Angular 9. I want the following features.

1) two data binding

2) lazy loading during virtual scroll

3) If I open excel with 1million rows entire application is loading for 2 to 3 mins and finally one pop up showing unsupported file. instead, it would be better if it shows something like one thousand first and then shows the rest of the record once the entire record is loaded. 

4) I want pivot table functionality inside the spreadsheet

5) for now how can I capture the scrolling event

Could you please give me the time frame when will I get these features(all features are a bit urgent for me).

[Arunkumar Devendiran]

Hi saravanan 

 

Query1: two data binding 

 

We would inform you that we have already considered this in our end and it will be included in our volume 1 SP1 release. Please follow the below feedback link. 

 

Feedback link: 

https://www.syncfusion.com/feedback/9684/dynamic-data-binding-support 

 

Query2: lazy loading during virtual scroll 

Query3: If I open excel with 1million rows entire application is loading for 2 to 3 mins and finally one pop up showing unsupported file. 

 

We would inform you that we have already considered this as improvement in our end and it will be included in our volume 2 release. Please follow the below feedback link. 

 

Feedback link: 

https://www.syncfusion.com/feedback/12829/server-side-virtual-scrolling-support 

 

4) I want pivot table functionality inside the spreadsheet 

 

We would inform you that we have already considered this as improvement in our end and it will be included in our volume 3 release. Please follow the below feedback link. 

 

Feedback link: 

https://www.syncfusion.com/feedback/12651/pivot-table-support-in-ej2-spreadsheet 

 

 

5) for now how can I capture the scrolling event 

 

We suspect that you are trying to get the data from the server while scrolling in the sheet. We would inform you that you can achieve this by using serverside virtual scroll. We will include this support in our volume 2 release and appreciate your patience until then. 

 

Could you please share with us if you need further support in our spreadsheet? 

 

Regards, 

Arunkumar D