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

[Somnath]

Hi,

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.

thanks,

Som

[Konduru Keerthi Konduru Ravichandra Raju]

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.

https://help.syncfusion.com/file-formats/xlsio/working-with-charts

https://help.syncfusion.com/file-formats/xlsio/working-with-pivot-tables

Regards,

Keerthi.

[Somnath]

Hi,

Is there a way to use chart for discontinuous ranges?

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

thanks

[Konduru Keerthi Konduru Ravichandra Raju]

Yes, Somnath.

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

https://help.syncfusion.com/file-formats/xlsio/faqs/how-to-create-a-chart-with-a-discontinuous-range