Hi Sruly,
There may be something buried in the Excel Active-X API to get the "point" position of a given cell, but I assume you are using the Excel Report instrument in CVI with
ExcelRpt_InsertPicture?
Since pictures can exist anywhere in a worksheet (not necessarily at a given cell), The
TOP and
LEFT parameters are specified in points where 1 point = 1/72 inches. In order to get the number of points that a set number of fixed height cells occupy, you could use the
ExcelRpt_GetCellRangeAttribute function with the
ER_CR_ATTR_ROW_HEIGHT attribute. This will return the height in points of the first row in the cell range, which you could multiply for as many rows as needed. To insert the picture below the third row, your code might look like the following:
int CVICALLBACK excel (int panel, int control, int event,
void *callbackData, int eventData1, int eventData2)
{
double rowHeight;
CAObjHandle worksheetHandle;
CAObjHandle workbookHandle;
CAObjHandle excelAppHandle;
switch (event)
{
case EVENT_COMMIT:
ExcelRpt_ApplicationNew (VTRUE, &excelAppHandle);
ExcelRpt_WorkbookOpen (excelAppHandle, "C:\\Book1.xls", &workbookHandle);
ExcelRpt_GetWorksheetFromIndex (workbookHandle, 1, &worksheetHandle);
ExcelRpt_GetCellRangeAttribute (worksheetHandle, "A1", ER_CR_ATTR_ROW_HEIGHT, &rowHeight);
ExcelRpt_InsertPicture (worksheetHandle, "C:\\Blue hills.jpg", rowHeight * 3, 0, 640, 480);
break;
}
return 0;
}Regards,
