Very Urgent

[Mohankumar]

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]

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]

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]

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]

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]

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]

Thanks a lot Geetha..


Thanks & Regards,
Mohankumar.V

[Mohankumar]

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]

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]

hi mohan,

could you pls share the code snippet?

thanks,

Senthil kumar

[Geetha M]

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]

Thanks Geetha.. its coming up...




Thanks & Regards,
Mohankumar.V

[Sridhar]

Hi Mohankumar,

 

Thank you so much for the  update.

 

Please let me know if you require any further clarifications.

 

Thanks,

Sridhar.S