We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Is there a way to use "Data Analysis" of Excel within Syncfusion?


Excel now has a feature called Data Analysis which makes it a lot easier for the user. I am using Syncfusion XlsIO and my objective is to do data analysis , make chart from an input file and using the output in some other place.

Obviously I can do it for a specific excel sheet where the column names are known a priori. But what happens if this is dynamic? Is there a way by which the system can suggest it? 

Any suggestion is greatly appreciated.



3 Replies

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team May 9, 2023 09:39 AM UTC

Hi Somnath, 

Currently, Syncfusion XlsIO has no support for the Analyze Data feature of Microsoft Excel and no plans to implement this feature. 

However, XlsIO has support for different Excel features such as charts and pivot tables which are created in data analysis. So, we request you to go through the below documentation for more information and try them manually.





SO Somnath May 10, 2023 08:49 AM UTC


Is there a way to use chart for discontinuous ranges?

For example, plotting data in column D versus column A.


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team May 11, 2023 05:58 AM UTC

Yes, Somnath.

It is possible to create a chart for discontinuous range. Please go through the below link for more information.


Live Chat Icon For mobile
Up arrow icon