Hi,
I have a chart/image in an Excel worksheet, is there any way I can get the address of the cell at the top-left of the chart? like if the top-left corner of the chart is coming on top of cell, how can I get that cell’s address?
eg. in the attached xls (book3.xls) the chart’s top left is coming in front of the cell D8, how can I programmatically get this value through your API?
Hi,
Thanks for providing us the template file.
May the following sample code help you for you need.
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook();
workbook.Open(@"d:\test\\Book313.xls");
Aspose.Cells.Chart chart = workbook.Worksheets[0].Charts[0];
int row = chart.ChartObject.UpperLeftRow;
int col = chart.ChartObject.UpperLeftColumn;
MessageBox.Show(CellsHelper.CellIndexToName(row,col));
Thank you.
Thank you Amjad Sahi…