Use NPOI(C#) to modify an existing chart from an existing XLSX

Asked Feb 09 '15 at 14:18

Active Feb 09 '15 at 14:18

Viewed 873 times

We have a workbook.xlsx with charts in its first sheet. How can we modify these charts? Like add "data labels" or change their "axis labels" position?

We can open the workbook (new XSSFWorkbook), get the sheet (workbook.GetSheet) and even reach the charts:

  XSSFDrawing drawing = sheet.CreateDrawingPatriarch() as XSSFDrawing;
  var charts = drawing.GetCharts();
  var chart = charts[1];

But that's how far we can go. There are not much properties, more kin of factories. And all available examples are about creating new charts.

Any idea?

asked Feb 09 '15 at 14:18

gpe

Did you manage to set range for the chart?@gpe – akd May 20 '15 at 14:20
No sorry. We switch to another library for other reasons. – gpe May 21 '15 at 08:04
Can you share which library? epplus? – akd May 21 '15 at 09:02
Exact. Are you a spy? – gpe May 21 '15 at 12:11
1

Thanks. No I am not a spy. – akd May 21 '15 at 14:41

Use NPOI(C#) to modify an existing chart from an existing XLSX

0 Answers0