How to stylize Chart based on other Chart with same type?

[dangraal]

Hi,

In Excel I can easily switch between different styles of charts.
I would like to prepare a chart with custom styling and I would want to apply the style or copy it on my other charts.

Is there any way I can achieve this in code?

[Marcia.Zhou]

Hello,

Thanks for your inquiry!

Please refer to the following code to copy the chart from one sheet to another sheet.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile("E:\\testdoc\\cusExcelStyle.xlsx");
            Chart chart = workbook.Worksheets["Sheet1"].Charts[0];

            Workbook newWork = new Workbook();
            Worksheet sheet = newWork.Worksheets[0];
            sheet.Charts.Add(chart.Clone(sheet));
            Chart chart2 = sheet.Charts[0];


If you encounter any other question, just feel free to contact us.

Sincerely,
Marcia
E-iceblue support team

[dangraal]

I don't want to clone entire chart.

I would like to copy only the style of it.
I have data on my chart and when I change the DataRange it also changes the style of it which I don't want.

I would like to have chart generated in code and apply the style of other chart without modyfing the data or similiar solution suitable for me.

[Marcia.Zhou]

Hello,

Sorry that our Spire.Xls does not support applying the system style or custom style to the chart, or get the style from a chart which has custom style yet. I have added this feature to our upgrade list. If there is any progress, we will keep you informed. Sorry for the inconvenience caused.

Sincerely,
Marcia
E-iceblue support team