Hi, I need help with the following problem :
I need to add a chart to my WorkSheet. After the chart is generated, and added to the worksheet, how can I know which rows/columns are hidden behind this newly added chart ?
i.e. after adding the chart, I need to add more values to the rows that occur below the chart. So, how can I compute the next available row below my chart ?
Thanks in advance <- src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" />

You can use the
ExcelChart.easy_getSeriesAt(index)
method to extract the series and
ExcelSeries.getValues() to see the row and columns behind the chart data.

If you want the chart position in the spreadsheet, you can set the size of the chart, so the chart will be always in the same position.
ExcelChart.setSize(int chartWidth, int chartHeight)
ExcelChart.setLeftUpperCorner(int row, int column)

thanks Daniela !
but, let me rephrase my question :
I meant : is there any way of knowing the lower right corner (row & col) of the chart that I add to the worksheet ?

If you know/set the chart size, you can calculate the lower row. The default row height is 17.
For the columns is more complicated. By default, the column width is adjusted to cell data content, so the column width is not fixed. But if you will set the column width for all columns, you can calculate the last column.

thanks Daniela !! <- src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" />
that should solve my problem.