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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Very Urgent

Thread ID:

Created:

Updated:

Platform:

Replies:

82677 Jun 18,2009 05:47 PM UTC Aug 30,2012 06:26 AM UTC ASP.NET Web Forms (Classic) 12
loading
Tags: XlsIO
Mohankumar
Asked On June 18, 2009 05:47 PM UTC

Hi,

Im getting this error 'The Type initializer for syncfusion.xlsio.excelutils threw an exception' while am trying to export to excel.

One more error is:

syncfusion.xlsio.implementation.applicationimpl. i have searched for this error n someone told to put compression.dll to the bin folder but still am gettin the same error.

can anyone help me on this. Your help would me much appreciated.

Thanks,
Mohankumar

Geetha M [Syncfusion]
Replied On June 19, 2009 11:32 AM UTC

Hi Mohankumar,

Thank you for your interest in Syncfusion products.

Could you please make sure if Syncfusion.Compression.Base is added as a reference to your application and placed in GAC ({Installed Drive}:\Windows\assembly\)?

Please let me know if you have any questions.

Regards,
Geetha

Mohankumar
Replied On June 19, 2009 01:22 PM UTC

Hi Geetha,

As you said, i have added those DLL's to assembly cache and it worked fine.

Many Thanks for you help!

One more issue geetha,

Im exporting the pie chart to excel, am able to export the chart, but am not able to display the series name & value. we can do tht manually by choosing the datalabels. is it any way to do tht thru code?


Thanks & Regards,
Mohankumar

Geetha M [Syncfusion]
Replied On June 24, 2009 01:22 PM UTC

Hi Mohankumar,

Thank you for the details.

I am afraid that I am not able to see the problem. Please try running the sample in the link below and send me the modified one so that I could recreate and find the cause of the same.

F82677

Regards,
Geetha

Mohankumar
Replied On July 10, 2009 06:28 PM UTC

Hi Geetha,

Sorry for the long delay. Actually the problem is,
am not able to display the value/percentage & the series name.
Legends are coming properly.

My chart is displaying without any value/percentage. if i mouse over the chart area, then am able to see the value in the tooltip.

am attaching the file. please check it out.


Thanks & Regards,
Mohankumar.V



chart_d314d191.jpg

Geetha M [Syncfusion]
Replied On July 13, 2009 01:53 PM UTC

Hi Mohankumar,

Thank you for the details.

Please use the code snippet given below to show Value and Percentage.

serie.DataPoints.DefaultDataPoint.DataLabels.IsPercentage = true;
serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
serie.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = true;

Please let me know if you have any questions.
Regards,
Geetha

Mohankumar
Replied On July 16, 2009 06:19 PM UTC

Thanks a lot Geetha..


Thanks & Regards,
Mohankumar.V

Mohankumar
Replied On August 9, 2009 06:23 AM UTC

Hi Geetha,

Still am not able to get the series name & value/percentage. i have used the below code.

IWorkBook chartbook = ExcelUtils.CreateWorkbook(2);
IWorksheet sheet = chartbook.Worksheets[0];

IWorksheet sheet1 = chartbook.Worksheets[1];

IChartShape chart = sheet1.Charts.Add();

DataSet reportDetails1 = (DataSet)Session["reportDetails1"];
sheet.ImportDatatable(reportDetails1.Tables[0],true,9,1);
chart.ChartType = ExcelChartType.Pie_Expoleded_3D;
chart.DataRange = sheet.Range["A10:D"+strcount];
chart.IsSeriesInRows = false;
chart.PrimaryCategoryAxis.categorylabels = sheet.Range["A10:A"+strcount];

is there any way to display the series name & value/percentage in IChartShape?

please help me in this..

Thanks in advance,
Mohankumar.V

Geetha M [Syncfusion]
Replied On August 12, 2009 10:05 AM UTC

Hi Mohan,

I regret for the delay in responding.

I am afraid that I am not able to reproduce the problem. You can check the sample in the link given below:

http://files.syncfusion.com/support/samples/XlsIO.Web/7.3.0.20/F82677/main.htm

Could you please try running the sample above and send me the modified version if you still face it?

Regards,
Geetha

Senthil Kumar
Replied On August 20, 2009 11:28 AM UTC

hi mohan,

could you pls share the code snippet?

thanks,

Senthil kumar

Geetha M [Syncfusion]
Replied On August 21, 2009 04:20 AM UTC

Hi Senthil,

You can get the sample demonstrating Pie Chart with Value and Percentage as DataLabels in the link below.

http://files.syncfusion.com/support/samples/XlsIO.Web/7.3.0.20/F82677/F82677.zip

Please try this and let me know if you need further details.

Regards,
Geetha

Mohankumar
Replied On August 24, 2009 05:57 AM UTC

Thanks Geetha.. its coming up...




Thanks & Regards,
Mohankumar.V

Sridhar [Syncfusion]
Replied On August 30, 2012 06:26 AM UTC

Hi Mohankumar,
 
Thank you so much for the  update.
 
Please let me know if you require any further clarifications.
 
Thanks,
Sridhar.S

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;