Create Chart without Datatable

[Semjasa]

Hello im Back again...

Im searching for any ways to Create Charts without writing this Data into datasources...

i want to create an chart and write data direct into this chart

a little bit like in OpenXML

Code: Select all

BarChartSeries barChartSeries = barChart.AppendChild(new BarChartSeries(
                        new Index() { Val = (uint)i },
                        new Order() { Val = (uint)i },
                        new SeriesText(new NumericValue() { Text = students[i].Name })
                    ));


[Lisa.Li]

Hello Semjasa,

Thanks for your post.
Please refer to the following sample code to achieve your requirement. If there is any question, just feel free to contact us.

Code: Select all

Workbook wb = new Workbook();
wb.LoadFromFile(@"sample.xlsx");
//Get the first worksheet
Worksheet sheet = wb.Worksheets[0];
//Add a chart to the worksheet
Chart chart = sheet.Charts.Add();
//Add a serie for the chart
var serie = chart.Series.Add();
//Add datas
serie.EnteredDirectlyValues = new object[] { 10, 20, 30};
wb.SaveToFile("result.xlsx",ExcelVersion.Version2013);


Sincerely,
Lisa
E-iceblue support team

[Semjasa]

THX, I'm blind.

im so sorry

nice support!

[Lisa.Li]

Dear Semjasa,

Thanks for your feedback. If you have other questions, please do not hesitate to contact us. Wish you all the best!

Sincerely,
Lisa
E-iceblue support team