We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to get cell index behind a chart

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…