Export multi series chart to excel | jQuery Forums

BP Baby Palanidurai Syncfusion Team June 19, 2019 05:40 AM

Hi Sutthipong,

Greetings from Syncfusion.

We have analyzed your query. We would like to let you know that the multi series chart export process same as like single series chart export. We have prepared a sample based on your requirement. In that we have used three series in the chart and export into excel type. Please find below sample and screenshot,

Screenshot:

Sample: https://jsplayground.syncfusion.com/vvqokgfl

Hope this helps.

Regards,

Baby.

SU Sutthipong June 21, 2019 03:47 AM

Sorry for late response.

If my server is not online must I implement server-side code?

If so what is the code for server-side function for https://js.syncfusion.com/demos/ejServices/api/Chart/ExcelExport

BP Baby Palanidurai Syncfusion Team June 24, 2019 05:09 AM

Hi Sutthipong,

Thanks for the update.

We have analyzed your query. We have attached server side code for ExcelExport method. Please find below code snippet,

Code Snippet:

ChartFeatures.cshtml:

<button onclick="download()" value="Export">Export</button>

@(Html.EJ().Chart("container").ExportSettings(ex => ex.Type(ChartExportingType.XLSX).Action("ExportChart")

.Mode(ChartExportingMode.Server))

</div>

function download(args) {

$("#container").ejChart("export");

}

</script>

ChartController.cs

//Export chart method in server side

public void ExportChart(string Data, string ChartModel)

{

ChartProperties obj = ConvertChartObject(ChartModel);

string type = obj.ExportSettings.Type.ToString().ToLower();

string fileName = obj.ExportSettings.FileName;

string orientation = obj.ExportSettings.Orientation.ToString();

ExcelExport exp = new ExcelExport();

exp.Export(obj, "", fileName + ".xlsx", ExcelVersion.Excel2010, null, null);

}

private ChartProperties ConvertChartObject(string ChartModel)

{

JavaScriptSerializer serializer = new JavaScriptSerializer();

IEnumerable div = (IEnumerable)serializer.Deserialize(ChartModel, typeof(IEnumerable));

ChartProperties chartProp = new ChartProperties();

foreach (KeyValuePair<string, object> ds in div)

{

var property = chartProp.GetType().GetProperty(ds.Key, BindingFlags.Instance | BindingFlags.Public | BindingFlags.IgnoreCase);

if (property != null)

{

Type type = property.PropertyType;

string serialize = serializer.Serialize(ds.Value);

object value = serializer.Deserialize(serialize, type);

property.SetValue(chartProp, value, null);

}

return chartProp;

}

Also here we have attached sample for your reference,

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/SyncfusionMvcApplication21260805754.zip

Demo: https://mvc.syncfusion.com/demos/web/chart/exports

Hope this helps.

Regards,

Baby.

SU Sutthipong June 24, 2019 05:24 AM

I getting System.InvalidOperationException at ConvertChartObject method

object value = serializer.Deserialize(serialize, type);

The exception message is Cannot convert object of type 'System.Boolean' to type 'Syncfusion.JavaScript.DataVisualization.Models.ConnectorLineStyle'

I attached the ChartModel that posted from export function

Attachment: chartmodel_6099219e.zip

KC Kalaimathi Chellaiah Syncfusion Team June 25, 2019 10:36 PM

Hi Sutthipong,

Thanks for the update.

We have analyzed your query. As of now, we can export SVG and canvas elements only. The tooltip, crosshair, connector lines and some other custom styles are created by html dev element, so we are unable export these elements. That’s why the exception is occurred. So we suspect if you are used connector line property in your sample then the reported issue has occurred when converting the chart model properties. Please revert if you need any other customization (or) further assistance.

Kindly revert us, if you have any queries.

Regards,

Kalai.

SU Sutthipong June 26, 2019 12:12 AM

In my graph setting I do not use lineconnector this is my code

$("#daychart").ejChart({

primaryYAxis: {

majorGridLines: { visible: false },

font: {

color:'black',

fontWeight:'bold',

size:'12px'

}

},

primaryXAxis: {

labelBorder: { width: 1 },

range: { interval: 1 },

crossesAt: 0,

showNextToAxisLine: false,

majorGridLines: { visible: false },

font: {

color:'black',

fontWeight:'bold',

size:'12px'

}

},

series: [

{

points: [],

fill: 'url(#chronicPattern)',

type: 'stackingColumn',

border: { color: "black", width: 1 },

marker: {

dataLabel: {

//Set text alignment to datalabel text

visible: true,

horizontalTextAlignment: "center",

font: {

fontWeight:'bold'

},

textPosition : "middle"

},

border: {

width: 0

},

visible: false

},

tooltip:

{

visible: true

}

},

{

points: [],

fill: 'url(#rpiPattern)',

type: 'stackingColumn',

border: { color: "black", width: 1 },

marker: {

dataLabel: {

//Set text alignment to datalabel text

visible: true,

horizontalTextAlignment: "center",

font: {

fontWeight:'bold'

},

textPosition : "middle"

},

border: {

width: 0

},

visible: false

}

},

{

points: [],

fill: 'url(#tagPattern)',

type: 'stackingColumn',

border: { color: "black", width: 1 },

marker: {

dataLabel: {

//Set text alignment to datalabel text

visible: true,

horizontalTextAlignment: "center",

font: {

fontWeight:'bold'

},

textPosition : "middle"

},

border: {

width: 0

},

visible: false

},

tooltip:

{

visible: true

}

},

{

points: [],

fill: 'url(#cviPattern)',

type: 'stackingColumn',

border: { color: "black", width: 1 },

marker: {

dataLabel: {

//Set text alignment to datalabel text

visible: true,

horizontalTextAlignment: "center",

font: {

fontWeight:'bold'

},

textPosition : "middle"

},

border: {

width: 0

},

visible: false

},

tooltip:

{

visible: true

}

},

{

points: [],

fill: "#996633",

type: 'line',

marker: {

dataLabel: {

//Set text alignment to datalabel text

visible: true,

horizontalTextAlignment: "center",

font: {

fontWeight:'bold'

}

},

border: {

width: 0

},

visible: true

}

},

{

points: [],

fill: "red",

dashArray: '5,5',

type: 'line',

},

],

commonSeriesOptions:

{

//To avoid overlap labels

enableSmartLabels: true,

},

legend: {

// ...

//Place the legend at top of the chart

alignment: 'far',

position: 'top',

},

title:

{

text: 'Daily',

position: "top",

textAlignment: "near",

maximumWidth: 150

},

axesRangeCalculate: function (sender) {

if (sender.data.axis.orientation == "vertical")

sender.data.range.max += sender.data.range.interval;

}

});

and this is my svg pattern fill

<path d="M-1,1 l2,-2

M0,4 l4,-4

M3,5 l2,-2"

style="stroke:#cccccc; stroke-width:1" />

</pattern>

<path fill-rule='evenodd' d='M0 0h4v4H0V0zm4 4h4v4H4V4z'

style="stroke:#cccccc; stroke-width:1" fill-opacity='0.4' />

</pattern>

</pattern>

</g>

</pattern>

</svg>

What am I need to remove to be able to export.

KC Kalaimathi Chellaiah Syncfusion Team June 26, 2019 12:54 PM

Hi Sutthipong,

Thanks for the update.

We have analyzed your query with the provided code snippet. From that, we found that issue occurred from the enableSmartLabels property. When we set enableSmartLabels property value as true, then the connector line automatically created if the data label is overlapped with another label. That’s why the reported problem has occurred. So we suggest setting enablesmartlabels property value as false. Also, we would like to let you know that the export method does not accept pattern format (fill:'url(#cviPattern)') fill colors of the chart series. We have prepared a sample using your code snippet. We have done mentioned changes in below sample and export is working fine at our end.

Screenshot:

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/multiseriesExport_modified_sample-1932892529.zip

Kindly check the above sample and revert us if still you have faced any problems.

Regards,

Kalai.

SU Sutthipong June 27, 2019 10:55 PM

But my client requirement is the series must be pattern fill. Is there a workaround for this.

KC Kalaimathi Chellaiah Syncfusion Team July 2, 2019 04:19 AM

Hi Sutthipong,

Thanks for being patience.

We have analyzed your query. There is no possibility to achieve your requirement in work around. Because when we export the chart all color which present in the chart properties will be converted into HTML color. In your case the color string is the id of the pattern, so we unable to convert the id in HTML color. That’s why the exception has occurred.

Kindly revert us, if you have any concerns (or) further assistance.

Regards,

Kalai.

SU Sutthipong July 4, 2019 11:58 PM

Never mind then.

My client not restricted me to export to excel so I export to other format with help of other library. It not perfect but acceptable.

BP Baby Palanidurai Syncfusion Team July 8, 2019 02:25 AM

Hi Sutthipong,

Thanks for the update. Kindly get in touch with us, if you would require further assistance. We are always happy in assisting you.

Thanks,

Baby.