Hi,

Is there any way of know how many lines a chart spans across a sheet rows and/or columns.

For example, suppose I need to add information to a sheet after adding a chart, with 600x300 (widthxheight), how many lines (and/or columns) should I assume the chart will use?


I've tried:


(hRows it's the number of rows we should skip and wColumns the number of columns we should skip)

This doen't solve completly my problem. The results aren't correct.

Any ideas?


Thanks in advance
Regards

Hi,

The chart size is not variable. For adding a chart please use ExcelWorksheet.easy_addChart(ExcelChart xlsChart, int row, int column, int width, int height) method.

Hi,

Thanks for you replay.

But you don't seem to see what is my problem.

Suppose i want to create the xls with this format:
<table border="1">
<tr>
<td width="100px">Text 1 </td>
<td width="100px">Text 2 </td>
<td width="100px"></td>
<tr>
<tr>
<td width="100px">-</td>
<td width="100px"></td>
<td width="100px"></td>
<tr>
<tr>
<td colspan="2" width="200px" height="200px">Image (600x300)</td>
<td width="100px">Text 3 </td>
<tr>
<tr>
<td width="100px">Text 4 </td>
<td width="100px"></td>
<td width="100px"></td>
<tr>
</table>

Using the API i know the columns for adding Text 1, Text 2, Text 3 and the Image.
But, when I try to add:

Text 3 - don't know wich column should I address (row is the same given for the image)

Text 4 - don't know wich row should I address (column is the same given for the image)

What I need is a way to convert (width, height) to (#columns, #rows).


Thanks

Hi,

Here's what I've found out for my problem:



Hope this helps others.

Regards