I have a template Excel spreadsheet which has 2 charts in it. I didn't design these charts its just my job to populate them with the correct data, and the person who designed the second chart put textboxes as labels within the chart area.
Using aspose I can populate the chart with data perfectly, however I need to be able to access these textboxes as the reports can be run in multiple languages, and so I need to update the textbox text to display the correct message for the selected language.
I've looked through the API and the developers guide but cannot find how to do this, am I missing something here? This is what I have so far:
Aspose.Cells.Workbook templateWorkbook = new Workbook();
templateWorkbook.Open(templateFileName);
Worksheet currentYearReportSheet = templateWorkbook.Worksheets["Report"];
//do data processing here and set NSeries data
I would like to be able to so something like:
currentYearReportSheet.Charts[1].TextBoxes.SetValue("Some Text")
Any Help would be great,
Thanks