Programatically change existing chart data through aspose cells

Aspose.Cells Product Family
1

Good morning,

I can create a chart is aspose cells however I read that the datatable can not be added this way so I created a chart in the original excel file and then try to call it using:

Dim chart13 As Chart = workbook.Worksheets(10).Charts(0)

However I am receiving an error :

7System.ArgumentOutOfRangeException: Index was out of range

I am manipulating the entire workbood and this is the last worksheet. I know the indexes are correct as I fill the worksheet with data using them and this is the only chart created on teh page.

Can I manually create a chart and then manipulate it using Aspose.Cells? Or am I doing something else incorrectly.

Thanks

2

Hi,

Yes, surely you can manipulate the designer charts using Aspose.Cells APIs: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/manipulating-designer-charts.html. Which version of Aspose.Cells you are using, kindly try the latest version 4.4.2.0 downloading @: http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry121168.aspx

If you still find any issue, kindly post your template excel file (containing the chart) here, we will check it soon.

Thank you.