1. Home
  2. Forum
  3. Angular - EJ 2
  4. pivot table in spreadsheet

pivot table in spreadsheet

Hi,

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

5 Replies
MV Madhan Venkateshan Syncfusion Team March 11, 2020 02:32 PM UTC

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:  
 
Please get back to us if you need further assistance. 
 
Regards, 
Madhan V 


SA saravanan replied to Madhan Venkateshan March 18, 2020 01:00 PM UTC

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:  
 
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

AD Arunkumar Devendiran Syncfusion Team March 19, 2020 01:20 PM UTC

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: 
 
Please follow the below feedback link. 
 
Regards, 
Arunkumar D   


SA saravanan March 23, 2020 12:30 PM UTC

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).

AD Arunkumar Devendiran Syncfusion Team March 25, 2020 03:41 PM UTC

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: 
 
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: 
 
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: 
 
 
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 


Loader.
Up arrow icon