excelize icon indicating copy to clipboard operation
excelize copied to clipboard

Published 20 hours ago • verified publisher icon qax-os

Graphs

Open dlion opened this issue 7 years ago • 5 comments

How can I "create" and "update" graphs in an xlsx files?

dlion avatar Mar 21 '17 09:03 dlion

@dlion Thanks for your issue, this library doesn't support to create or update charts in xlsx. I intend to add this function next. Try to open a pre-designed document that includes the chart, modify the value referenced by the chart if you can in current.

xuri avatar Mar 21 '17 10:03 xuri

@Luxurioust I need to write a tool to automatize some steps. I need to add a value in a row on the sheet1, looking for a certain sheet (by name for example), adding in it some values, update a chart, switch to another sheet, add the same values and update 2 charts, switch to another sheet and modify some values. Is an huge job so I wish to automatize it.

Do you have any documentation to read how xlsx files works? Thanks in advantage!

dlion avatar Mar 21 '17 10:03 dlion

The xlsx file follows the OOXML specification. XML is compliant with part 1 of the 4th edition of the ECMA-376 Standard for Office Open XML. Use DrawingML to generate charts.

xuri avatar Mar 21 '17 10:03 xuri

@dlion Hi, I have added new function AddChart(). This is just an initialization of the chart support and I'll continue to optimize this.

xuri avatar Apr 25 '17 10:04 xuri

Is there any functionality for changing the chart? For example, the ChangeChart () function?

nsemikov avatar Mar 20 '18 15:03 nsemikov